DynamicZip Table Conversions are required whenever the design of a DZ table is modified.

The 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:

1. A temp table gets created that has the new modified format.
2. 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.
3. 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.
4. The table gets created with the new format. (ie. the “new” table)
5. The records get copied from the temp table into the new table.
6. 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 drop the table and create a fresh empty one.

If this does not resolve the conversion issue, please submit a tech support request to us.

FAQ