Changing from 2005 Standard to 2012 Enterprise

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2012 » SQL 2012 - General » Changing from 2005 Standard to 2012...

Changing from 2005 Standard to 2012 Enterprise - Any advice please?

Rate Topic

Display Mode

Topic Options

Author

Message

Ross.M

Posted Monday, February 18, 2013 2:02 AM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 10:54 AM
Points: 214, Visits: 323

I'm a DBA, I'm not a master by any means, been doing this for just under a year, prior to that I was in MI for 2-3 years in a couple of other companies, everything up until now has been SQL Server 2005 Standard Edition. The company I'm working for is now switching to 2012 Enterprise Edition.

I'm really just looking for any advice, or insiders tips on what I should be reading up on and studying for the transition, are there any tutorials or articles that were particularly more useful than others, for any of you who have gone through the same transition? And are there any pieces of advice you could throw my way that articles or tutorials do not mention?

Thanks in advance :)

Post #1421088

anthony.green

Posted Monday, February 18, 2013 2:13 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

You have 2 routes, inplace or side by side.

Safest is side by side.
2 ways of side by side,
1. a new box with a new install of sql, restore the database copy all server wide objects etc and change our connection strings then test
2. install a named instance on the same box, then restore, change connection strings and test.

Its the safest way as you have your old server running at the same time so if any issues arrise you can fail back without impacting anything.

In place is a bit tricky as you literally upgrade the existing installation, so if anything should happen you need to uninstall 2012 install 2005 restore everything

Before you do anything always take a full backup of all databases including your system databases, script out all logins, jobs, ssis packages, linked server etc etc and store them on a network location somwhere for safe keeping.

I have attached a white paper on a 2012 upgrade.

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1421100

Ross.M

Posted Monday, February 18, 2013 2:20 AM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 10:54 AM
Points: 214, Visits: 323

Thank you Anthony, very helpful Smile

And the attached whitepaper looks pretty in-depth!

Post #1421101

« Prev Topic | Next Topic »

Permissions