Move DB from 2008R2 Enterprise to 2008 Standard

  • 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?

  • 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.

  • Can I use the Copy Database wizard?

  • 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.

  • 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" 😉

  • 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

  • You can only exprot the data and use.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply