Red Gate forums :: View topic - SQL downgrade
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare 10
SQL Data Compare 10 forum

SQL downgrade

Search in SQL Data Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
klundy



Joined: 13 Dec 2013
Posts: 1

PostPosted: Fri Dec 13, 2013 8:28 pm    Post subject: SQL downgrade Reply with quote

Can SQL Compare and Data Compare be used to efficiently downgrade a SQL database from 2008 R2 to 2008?

I'm searching to help a client who upgraded and didn't fully test. A few of the downgrade articles mentioned using Redgate tools. I've browsed the documentation and it seems like it might, but I would like confirmation.

Thank you for any comments or advice.
Kevin
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 941
Location: Red Gate Software

PostPosted: Mon Dec 16, 2013 12:29 pm    Post subject: Reply with quote

Thank you for your forum post.

Yes, you can use SQL Compare and SQL Data Compare to compare a SQL 2008 R2 to a SQL 2008 database and then deploy from the 2008 R2 database to the 2008 database.

You will need to be careful with regards to features new in the 2008 R2 database. If the source SQL 2008 R2 database is making use of any new features that are not available in SQL 2008, the deployment process will most likely fail.

I hope this answers your question.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
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