Red Gate forums :: View topic - Is this possible with your SQL Compare ?
Return to www.red-gate.com RSS Feed Available

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

Is this possible with your SQL Compare ?

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



Joined: 31 Oct 2012
Posts: 1

PostPosted: Wed Oct 31, 2012 6:34 am    Post subject: Is this possible with your SQL Compare ? Reply with quote

I have a SQL Server 2008 R2 Database and i need to downgrade it to SQL Server 2008(not R2) Database without losing any data in it.

Is this possible ? Is so how can i do that
Back to top
View user's profile Send private message
eddie davis



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

PostPosted: Wed Oct 31, 2012 1:51 pm    Post subject: Reply with quote

Hi

Thank you for your forum post.

It may be possible for you to downgrade a SQL 2008 R2 database to SQL 2008, but will require SQL Compare and SQL Data Compare.

Use SQL Compare to compare and deploy the database schema, followed by SQL Data Compare to compare and deploy the data.

The basic steps are as follows:

    1. Create a new database on the SQL 2008 instance.
    2. Using SQL Compare, compare the SQL 2008 R2 database (as the source) with the SQL 2008 database (as the target).
    3. Use the SQL Compare deployment wizard to deploy the objects that exist in the SQL 2008 R2 to the target SQL 2008. Once the schemas are identical, you can then synchronize the data.
    4. Using SQL Data Compare compare the data between the SQL 2008 R2 database (as the source) with the SQL 2008 database (as the target).
    5. Use the SQL Data Compare deployment wizard to deploy the data that exists in the SQL 2008 R2 to the target SQL 2008.


I hope the above helps.

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