August 21, 2015 at 2:25 am
Hello everyone,
We're planning to upgrade our existing setup from SQL 2008 R2 to SQL 2014 at Azure.
The new server is up and running with SQL 2014.
Now, my job is to move all databases and SQL jobs to this new server.
Then, test command line database build and convert all existing SSIS Packages.
Once I prepare this server, the next task is to prepare 2 QA servers in a similar manner.
And finally, the production server.
Can anybody please advise what needs to be taken care to complete this job successfully?
Also, please advise how to prepare the templates or scripts, which could be reused for other servers down the line.
Likewise, please suggest how to get the maximum benefits/advantages of SQL 2014 at Azure?
Like,
Any help would be greatly appreciated.
Thanks,
Ankit
August 21, 2015 at 12:27 pm
You're basically doing the same thing as a side-by-side upgrade. That's a very straight forward mechanism. Lots of documentation out there on it. You have options and it depends on how big your databases are and how much down time you can afford. The most straight forward mechanism is to backup the existing databases and then restore them to the new server. But you could also set up log shipping as a way to minimize down time if you need to. Just do a search on the web, you'll find tons of examples on how to do a side-by-side install. The only really tricky part is getting the logins transferred. Here are several choices on how to approach that. Also make sure you script out your SQL Agent jobs from the 2008 database and run that script to recreate them on the 2014 machine.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply