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

snapshot compatible with ms sql 2000

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!
ilya
0

Comments

1 comment

Sort by
  • Brian Donahue
    Hi,

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

Add comment

Please sign in to leave a comment.