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 | |
|---|---|---|---|---|
| Schema Compare doesn't generate script for table diffs | 5 | 1863 | August 26, 2019 | |
| Compare schemas question(altering table instead of dropping and recreating) | 10 | 1940 | May 6, 2015 | |
| Copying tables in SQL | 3 | 1078 | August 30, 2019 | |
| Toad for Sql Server v6.0 has been released! | 5 | 834 | June 20, 2013 | |
| Schema Compare | 9 | 753 | September 21, 2010 |