Post reply

Ways to Migrate multiple databases to a newer SQL Version

  • March 21, 2012 at 3:04 pm

    #255170

    Hello,

    I m currently planning to migrate databases to a newly installed Sql Server.

    Can anyone please let me know if there is any optimized/easier way we can migrate multiple databases(100 +) to a new sql version.

    I m aware that there are many ways to do so, but apart from those i m interested to know if there is an easy way out apart from doing a restore or detach/attach method for 100+ databases.

    Thanks for the help!!

  • March 21, 2012 at 3:34 pm

    #1462455

    No easy cut and paste way. You can generate a couple of scripts using dynamic sql to attach/detach. Perhaps a powershell script to wrap it up and do the copying and folder creation.

    Best advice is to ensure the drive letters match the source server. This will prevent a lot of file moving making the attach/detach process more complicated.

    Alternatively, you could look at logshipping then all prior to migration. This can be prepped well in advance and it will vastly reduce the copying process.

Viewing 2 posts - 1 through 1 (of 1 total)

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