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

snapshot compatible with ms sql 2000

ilyailya Posts: 19
edited August 15, 2008 12:50PM in SQL Compare Previous Versions
We have ms sql 2005 as an etalon database. Is there a possibility to create a snapshot of ms sql 2005 database compatible with ms sql 2000?

The problem is: we use sql toolkit to compare and synchronize sql 2000 database with a snapshot of a 2005 database (which iself is compatible with 2000).

The sinchronization fails on 2000 database and not on 2005 database.

Thanx for any help!


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1

    SQL Compare can compare SQL 2000 and SQL 2005 databases. When the second database (the one on the right) is a SQL Server 2000, then the script produced will be compatible with SQL Server 2000. However, there are some circumstances where this is impossible -- for instance if you have a CLR user-defined function that is the default for a column on a table. Since SQL 2000 didn't have assembly support, it would be impossible to migrate the UDF and therefore impossible to create the default.
Sign In or Register to comment.