====== What do I do when a table conversion fails? ======
DynamicZip [[dynamiczip:tables:conversions:Table Conversions]] are required whenever the design of a DZ table is modified.

The [[dynamiczip:windows:DZ Table Status window]] has been designed to determine if any DZ tables need to be upgraded/converted, and if so, it can also help you convert those table(s).

The following processes occur during a table conversion:

  - A temp table gets created that has the new modified format.
  - The records in the original table are copied to the temp table.     
    * If this or the above step fails, the original table should be completely unchanged and the conversion can be reattempted.
  - The original table is dropped (ie deleted).     
    * If the conversion fails after this point, you will need to restore the table from a backup and restart the conversion process. Although a table could get damaged during the conversion, it is very rare. At the time of this writing we have had no reports of this happening.
  - The table gets created with the new format. (ie. the "new" table)
  - The records get copied from the temp table into the new table.
  - The temp table is dropped.

If you are unable to salvage the table and it is empty or contains data that can be easily replaced, you can [[dynamiczip:faq:Drop Recreate Sql Table Faq|drop the table and create a fresh empty one]].

If this does not resolve the conversion issue, please submit a [[mailto: support@kampdata.com|tech support request ]]to us. 

----

[[dynamiczip:faq:Frequently Asked Questions|FAQ]]