synchronization of 2000 with snapshot of 2005

Forum for users of SQL Toolkit 3,4,and 5

synchronization of 2000 with snapshot of 2005

Postby ilya » Fri Aug 15, 2008 4:44 pm

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!!
ilya
 
Posts: 13
Joined: Wed Jul 30, 2008 9:28 am

Postby Michelle Taylor » Mon Aug 18, 2008 10:32 am

Try switching the 2005 database to compatibility mode 80? It sometimes helps with this.
Michelle Taylor
 
Posts: 529
Joined: Mon Oct 30, 2006 12:45 pm
Location: Red Gate Software


Return to SQL Toolkit Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests