Red Gate forums :: View topic - synchronization of 2000 with snapshot of 2005
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Toolkit Previous Versions
SQL Toolkit Previous Versions forum

synchronization of 2000 with snapshot of 2005

Search in SQL Toolkit Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
ilya



Joined: 30 Jul 2008
Posts: 13

PostPosted: Fri Aug 15, 2008 4:44 pm    Post subject: synchronization of 2000 with snapshot of 2005 Reply with quote

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!!
Back to top
View user's profile Send private message
Michelle Taylor



Joined: 30 Oct 2006
Posts: 528
Location: Red Gate Software

PostPosted: Mon Aug 18, 2008 10:32 am    Post subject: Reply with quote

Try switching the 2005 database to compatibility mode 80? It sometimes helps with this.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group