snapshot compatible with ms sql 2000
ilya
Posts: 19
Hi!
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!
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!
Comments
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.