Migrate SQL 2008 R2 database to SQL 2008?

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Migrate SQL 2008 R2 database to SQL 2008?

Postby msandico » Wed Jun 12, 2013 10:05 pm

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.
msandico
 
Posts: 6
Joined: Thu Aug 16, 2012 3:12 pm

Postby eddie davis » Thu Jun 13, 2013 8:17 am

Hi

To answer your question:
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
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby msandico » Thu Jun 13, 2013 2:46 pm

Perfect thank you!
msandico
 
Posts: 6
Joined: Thu Aug 16, 2012 3:12 pm


Return to SQL Compare 10

Who is online

Users browsing this forum: Bing [Bot] and 1 guest