Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Changing from 2005 Standard to 2012 Enterprise - Any advice please? Expand / Collapse
Author
Message
Posted Monday, February 18, 2013 2:02 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 10:21 AM
Points: 280, Visits: 528
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
Posted Monday, February 18, 2013 2:13 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 8:53 AM
Points: 5,218, Visits: 5,072
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
Posted Monday, February 18, 2013 2:20 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 10:21 AM
Points: 280, Visits: 528
Thank you Anthony, very helpful

And the attached whitepaper looks pretty in-depth!
Post #1421101
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse