synchronization of 2000 with snapshot of 2005

ilya

Hi!

Using SQL Toolkit we try to sinchronize a ms sql 2000 database with a snapshot of a ms sql 2005 database.

2005 database is compatiblle with ms sql 2000.

If we run synchronization of 2000 database with a snapshot of 2005 databse, it fails (the update script genrated by sql toolkit contains 2005 specifically syntax).

Is it possible to get update scripts in the ms sql 2000 syntax or to get a snapshot of 2005 database in the 2000 compatible mode, so that the update scripts will be generated for 2000 dfatzabase?

Thanks for any help!!

Michelle T

Try switching the 2005 database to compatibility mode 80? It sometimes helps with this.