Sign in with
Sign up | Sign in
Your question
Solved

Sql Expert Needed....

Tags:
  • Business Computing
  • SQL
Last response: in Business Computing
Share
July 19, 2013 8:38:08 PM

I'm currently upgrading an sql 2005 which i'm pretty fimiliar with, to sql 2012, my question is how would you guys go about doing this, server 2012 will be ran on top of it of course

More about : sql expert needed

Best solution

August 2, 2013 7:55:36 AM

This is a SQL2005 application you are upgrading to SQL2012?

I'd do it the way I'd do any platform upgrade;
1. Create a full clone of the existing application in a test environment.
2. Upgrade it to SQL2012.
3. Test it thoroughly. See what breaks and figure out how to fix it.
4. Do it again, documenting exactly what needs to be fixed to make it run in the new environment.
5. Prior to actually doing it with the production application, create a full backup, just in case.
6. Once you have all needed changes documented, inform the users "The system is going offline Friday at 5PM. Hopefully back online NLT Monday at 7AM."

Take it offline Friday, do the upgrade, fix it over the weekend. Turn it back on before Monday morning. If things go bad, roll back to the backup SQL2005 you made in step 5.
Share
!