I have TOAD for SQL Server version 6.1. When doing a schema compare between two databases and generating a script I’m finding that TOAD’s sync script always generates a drop and re-creation of a table no matter how small the change (example: simply expanding the size of a field). Since the database I’m converting has very large tables it’s very time consuming to have these tables re-created along with the indexes rather than the script using a simple Alter table command. Is there an option that I’m missing where I can have the tables altered or will the script always generate a mandatory re-creation of the table?
Related topics
Topic | Replies | Views | Activity | |
---|---|---|---|---|
Compare schemas question(altering table instead of dropping and recreating) | 10 | 2002 | May 6, 2015 | |
Schema Compare doesn't generate script for table diffs | 5 | 1887 | August 26, 2019 | |
Looking how to compare 2 sql express db and create from the dif a script file | 1 | 740 | June 12, 2013 | |
Copying tables in SQL | 3 | 1086 | August 30, 2019 | |
Generate Alter Script From Model Comparison | 2 | 1036 | December 16, 2020 |