-
Title
Script generated by Sync & Convert | Generate Alter Script option does not preserve table data -
Description
In Toad Data Modeler 4.3, Sync & Convert | Generate Alter Script option is used to compare a model with an RE alias. The generated script to synchronize table structure does not preserve table data. Toad Data Modeler 4.2 generates a different script that preserves this data.
Toad 4.3 script:
DROP TABLE...
CREATE TABLE...
Toad 4.2 script:
INSERT INTO TempTable SELECT id, table1_id, table1_desc FROM Table1
DROP TABLE Table1
ALTER TABLE TempTable RENAME TO Table1 -
Resolution
1. Select Settings | Options menu option
2. Go under Model | Physical node
3. There is a node for each database platform, such as one called "Microsoft SQL Server"
4. Select this node and on the right hand side a checkbox called "Use Temporary Tables to Preserve Data" checkbox is shown
5. Check this box for this section and the all other database platform sections Physical node -
Additional Information
By default above option is enabled in version 4.2.