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