ER/Studio DA V19.1.1 -- Merge script incorrect

Using DA v19.1.1 I did a model compare against a live database. Differences were correctly identified. However, when the merge script was generated, there were several errors in the script. Because columns were entered in the middle of tables, the tables were renamed, created with the new columns in correct order, and then existing data was inserted into the new table using a select from the previously renamed table. The table included an IDENTITY column, so SET IDENTITY_INSERT tablename ON/OFF was needed. DA failed to include the table name as part of the statement, simply writing in the script SET IDENTITY_INSERT   ON followed by SET IDENTITY_INSERT   OFF. Obviously, this would not work without the table name.

Also, DA failed to Drop or rename all necessary FK constraints, resulting in another problem when the script was run.

Using V16 of DA, I was able to create a correct Merge script. 

Anyone else experience a similar problem? Looks like the Compare/Merge functionality took several steps back.

Parents Reply Children
No Data