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

  • 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 🙂

  • 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.

  • Thank you Anthony, very helpful 🙂

    And the attached whitepaper looks pretty in-depth!

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

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