How can we help you today? How can we help you today?

Syncronizing an SQL 2000 database with SQL 7.0

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!
Brian Donahue
0

Comments

1 comment

Sort by
  • Brian Donahue
    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.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.