Differences

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

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