Differences

This shows you the differences between two versions of the page.

--- dynamiczip:tables:conversions:table_conversion_script_report_options [2015/03/16 22:01] – external edit 127.0.0.1
+++ dynamiczip:tables:conversions:table_conversion_script_report_options [2015/05/11 19:45] (current) – removed chuck
@@ Line 1: / Line 1: @@
-====== Report Options table Conversion Script ======
-The following process is an alternative method that can be used to convert the [[dynamiczip:tables:DZ Report Options table]] from build 69 to [[dynamiczip:install:mods:release:build70:build70|Build 70]] or later. The [[dynamiczip:windows:DZ Table Status window]] provides the standard method for table conversions.
-  - Create a temp table to store the contents of the existing permanent table.
-  - Copy the records from the existing permanent table to the new temp table.
-  - [[dynamiczip:glossary:Drop_Recreate_Table|Drop & Recreate]] the existing permanent table to replace it one having the new format.
-  - Copy the records from the temp table to the new permanent table.
-  - Drop the temp table.
-Use the attached SQL scripts to perform steps 1, 2, 4 and 5 above. You will need to modify the name of the company database from MACRO to whatever is appropriate for your installation.
-Attachment: {{dynamiczip:DZ70501-1-CreateTemp.sql}}\\
-Attachment : {{dynamiczip:DZ70501-2-CopyToTemp.sql}}\\
-Attachment : {{dynamiczip:DZ70501-4-CopyToNew.sql}}\\
-Attachment : {{dynamiczip:DZ70501-5-DropTemp.sql}}
-----
-[[dynamiczip:tables:tables|DynamicZip Tables]]\\
-[[dynamiczip:tables:conversions:Table Conversion Scripts]]