Question:
During Complete Compare, in the Alter Script/Schema Generation there used to be a Save Data button where I could force the drop and recreate of tables and that also used a table rename and insert into the new tables to preserve the data. Where are those options in the 2018 R1 version?
Solution:
in 2018 R1 version it always saves the data in the Alter Script / Schema Generation, unless you turn on Force Alter Syntax in the Other Options.
Figure 1. Force ALTER Syntax disabled.
Figure 2. Save data occurs.
In the earlier versions of erwin DM, there used to be a Save Data button. That button has been replaced as per the above functionality.
Figure 3. erwin DM r9.8 and earlier versions of erwin DM had a Save Data button that would be used.
Figure 4. In 9.8 and previous versions that would open this second window where you could Force DROP/re-CREATE Table and preserve the data.
So erwin DM 2018 R1 saves the data by default unless you check on Force Alter Syntax in the Other Options.
Comments
0 comments
Please sign in to leave a comment.