Differences

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

--- dynamiczip:tables:conversions:table_conversion_script_tax_detail_supplement [2015/04/27 22:18] – external edit 127.0.0.1
+++ dynamiczip:tables:conversions:table_conversion_script_tax_detail_supplement [2015/05/11 19:46] (current) – removed chuck
@@ Line 1: / Line 1: @@
-======Tax Detail Supplement Table Conversion Script======
-The following process is an alternative method that can be used to convert the [[dynamiczip:tables:DZ Tax Detail Supplement table]] from build 69 or earlier 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.
-{{dynamiczip:DZ00400-1-CreateTemp.sql}} \\
-{{dynamiczip:DZ00400-2-CopyToTemp.sql}} \\
-{{dynamiczip:DZ00400-4-CopyToNew.sql}} \\
-{{dynamiczip:DZ00400-5-DropTemp.sql}} \\
-----
-[[dynamiczip:tables:tables|DynamicZip Tables]]\\
-[[dynamiczip:tables:conversions:Table Conversion Scripts]]