What are the challenges you face when working across database platforms? Take the survey

Syncronizing an SQL 2000 database with SQL 7.0

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited November 29, 2005 6:21AM in SQL Compare Previous Versions
Hi Tim,

Thanks for asking. You can make the scripts SQL 7 compatible by using the 'ignore collation order' setting in SQL Compare. This will stop SQL Compare from scripting collation settings on individual columns, which isn't supported in SQL 7.

That should save you from having to upgrade your SQL Server!


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    There is now some information in the help file about this as well as in our FAQ:
    If you are comparing databases and want to run the scripts on a SQL Server 7 server, or want to ignore features not available in SQL 2000, then you should set the following options:

    Ignore collation order
    Ignore INSTEAD OF triggers

    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.
This discussion has been closed.