Options
SC 3 - Migrate database schema from SQL 2000 to SQL 7
Brian Donahue
Posts: 6,590 Bronze 1
Date: 14 Sep 2004
Affects versions: 3.x
In previous versions of SQL Compare, there was an option to create SQL 7 compatible scripts to filter out SQL 2000 specific features from the script so that it would not fail if running on SQL 7. In SQL Compare 3, this option was eliminated.
It is still possible to migrate a schema from SQL 2000 to SQL 7, however, by changing the settings in the Options in the Comparison menu to:
•Ignore collation order
•Ignore INSTEAD OF triggers
•Ignore Extended Properties
In addition, you might need to manually modify the scripts to remove references to, for example, ascending indexes and computed columns containing user-defined functions.
Affects versions: 3.x
In previous versions of SQL Compare, there was an option to create SQL 7 compatible scripts to filter out SQL 2000 specific features from the script so that it would not fail if running on SQL 7. In SQL Compare 3, this option was eliminated.
It is still possible to migrate a schema from SQL 2000 to SQL 7, however, by changing the settings in the Options in the Comparison menu to:
•Ignore collation order
•Ignore INSTEAD OF triggers
•Ignore Extended Properties
In addition, you might need to manually modify the scripts to remove references to, for example, ascending indexes and computed columns containing user-defined functions.
