Red Gate forums :: View topic - Migrate SQL 2008 R2 database to SQL 2008?
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

Migrate SQL 2008 R2 database to SQL 2008?

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



Joined: 16 Aug 2012
Posts: 6

PostPosted: Wed Jun 12, 2013 10:05 pm    Post subject: Migrate SQL 2008 R2 database to SQL 2008? Reply with quote

Hi there,

Can SQL Compare take the contents of an entire database (schema, data, users, etc..), and generate scripts that can be applied to an empty SQL 2008 database?

We have a SQL 2008 R2 database that needs to go back to SQL 2008.

Thanks in advance.
Back to top
View user's profile Send private message
eddie davis



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

PostPosted: Thu Jun 13, 2013 8:17 am    Post subject: Reply with quote

Hi

To answer your question:
Quote:
Can SQL Compare take the contents of an entire database (schema, data, users, etc..), and generate scripts that can be applied to an empty SQL 2008 database?


The simple answer to your question is yes, but you need to use SQL Compare and SQL Data Compare to achieve your goal.

Using SQL Compare, you will be able to compare the SQL 2008 R2 database with an empty SQL 2008 and deploy to the empty database so that they become identical with regards to the database objects or schema.

Next using SQL Data Compare, you will be able to compare the data between the 2008 R2 database to the 2008 database (that has no rows of data) and deploy the data to the SQL 2008 database.

The only thing to be aware off, if the SQL 2008 R2 database is using features that are not available in the SQL 2008, these cannot be deployed to the SQL 2008 database.

I hope the above 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
msandico



Joined: 16 Aug 2012
Posts: 6

PostPosted: Thu Jun 13, 2013 2:46 pm    Post subject: Reply with quote

Perfect thank you!
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