Move DB from 2008R2 Enterprise to 2008 Standard

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Move DB from 2008R2 Enterprise to 2008...

Move DB from 2008R2 Enterprise to 2008 Standard

Rate Topic

Display Mode

Topic Options

Author

Message

mcopa

Posted Monday, September 24, 2012 11:12 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, May 16, 2013 11:54 AM
Points: 14, Visits: 62

I am moving a database via backup/restore from a 2008r2 Enterprise server to a 2008 Standard server. Since it is kind of a downgrade of versions, is there anything special I need to run after the restore is completed?

Post #1363639

Lynn Pettis

Posted Monday, September 24, 2012 11:15 AM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 12:16 PM
Points: 21,621, Visits: 27,455

If you are going from 2008 R2 to 2008, you won't be able to use the backup/restore. You will need to script your database on SQL Server 2008 R2, and create an empty database in 2008. Then use SSIS to transfer the data from 2008 R2 to 2008.

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #1363640

mcopa

Posted Monday, September 24, 2012 11:29 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, May 16, 2013 11:54 AM
Points: 14, Visits: 62

Can I use the Copy Database wizard?

Post #1363649

Lynn Pettis

Posted Monday, September 24, 2012 11:41 AM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 12:16 PM
Points: 21,621, Visits: 27,455

mcopa (9/24/2012)

Can I use the Copy Database wizard?

Probably. I have had issues using it myself, so I tend to script the database then use SSIS to transfer data.

Cool

Lynn Pettis

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #1363656

Perry Whittle

Posted Monday, September 24, 2012 12:11 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 5:53 AM
Points: 5,204, Visits: 11,158

mcopa (9/24/2012)

Can I use the Copy Database wizard?

if you use the detach\attach method no you can't.
If you use the object method trnasfer it might work as it reads the objects and then recreates them and then copies data

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" Wink

Post #1363670

chandan_jha18

Posted Tuesday, September 25, 2012 6:27 AM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 2:31 AM
Points: 412, Visits: 1,671

Script out objects as Lynn suggested and use SSIS to import the data. Else you can also go for the replication option to minimize the downtime.

Thanks
Chandan

Post #1363979

vyas

Posted Tuesday, September 25, 2012 6:29 AM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, May 16, 2013 4:02 AM
Points: 3,131, Visits: 1,056

You can only exprot the data and use.

Post #1363983

« Prev Topic | Next Topic »

Permissions