Solved

Upgrade of SQL Server 2005

Posted on 2013-05-24
12
292 Views
Last Modified: 2013-05-28
Hi,
We would like to upgrade our current version of SQL server 2005 to 2012.  Is this version stable?  It seems like going to 2008 is already outdated?

Thoughts?

Thanks,
hefterr
0
Comment
Question by:hefterr
  • 5
  • 4
  • 3
12 Comments
 
LVL 34

Expert Comment

by:Brian Crowe
ID: 39195461
There is also another version in between: 2008 R2 which is essentially 2010.  2012 is fairly widely used and I would suggest going to 2012 if you're going to go to all the trouble of upgrading.
0
 
LVL 1

Author Comment

by:hefterr
ID: 39195498
How painful is the upgrade to 2012?  Do you think the upgrade to 2012 is the same effort as to 2012 or 2008?
0
 
LVL 34

Assisted Solution

by:Brian Crowe
Brian Crowe earned 250 total points
ID: 39195528
I personally haven't done an upgrade to 2012 but all of my upgrade efforts in the past have been relatively painless.  The only exception has been some CLR procedures.  Obviously I would recommend installing whatever you choose in a test environment and walking through the upgrade there and then reattaching test versions of any applications that point to it and doing some regression testing.
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LVL 1

Author Comment

by:hefterr
ID: 39195547
We are not using CLR procedures.  I assume there still is a Management Studio and it has not been revamped too much?
0
 
LVL 34

Expert Comment

by:Brian Crowe
ID: 39195589
You won't feel lost in the new SSMS and I'm sure you'll appreciate the intellisense in the query editor that was introduced with 2008.
0
 
LVL 8

Accepted Solution

by:
didnthaveaname earned 250 total points
ID: 39195723
The move isn't bad at all. I am currently migrating a 2005 to 2012.  Some of the things you should be aware of involve the fact that if your 2005 instance is sitting on windows 2003, you will have to migrate to a new server that is on server 2008, 2008r2, or 2012 (you would need a migration vs. in place upgrade also if you are switching from 32 bit to 64 bit binaries for SQL Server).  In those instances, you would be looking at a migration and not an in place upgrade.  You have several options available for that, I would suggest taking a look at my post here: http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_28121746.html#a39148501.

Beyond that, you'll want to check your deprecated/discontinued features moving from 2005 to 2012, to ensure that you don't rely on anything that is discontinued:

http://msdn.microsoft.com/en-us/library/ms144262%28v=sql.105%29.aspx

http://msdn.microsoft.com/en-us/library/ms144262%28v=sql.110%29.aspx

Beyond that, if you have mixed mode authentication (and frankly, even if you don't, this saves time), there is a link in the article regarding migration options to copy over the server login principals which I would encourage you to take a look at.  If you do have SQL Server authenticated logins, it will ensure that the SIDs in the new server are the same as the old and whenever you restore databases, you won't have to remap the users.  Hope that helps!
0
 
LVL 1

Author Comment

by:hefterr
ID: 39195766
We are migratin from a 32 bit dedicated server to a 64 bit virtual/cloud environment and we are using this check out period/opportunity to upgrade SQL server 2005.  I belive the OS will be Win server 2008.

Any thoughts on 32 bit versus 64 bit?

Thanks again.
0
 
LVL 8

Expert Comment

by:didnthaveaname
ID: 39195797
I personally like 64 bit vs 32 bit for the simple fact that large memory support is native. There are other reasons to make the move, I encourage you to check out this article: http://www.microsoft.com/sqlserver/2005/en/us/64-bit.aspx
0
 
LVL 8

Expert Comment

by:didnthaveaname
ID: 39195808
Also, since you mentioned moving to a virtual environment, I would recommend additional consideration be given to how you want to configure your storage. Here's a good comparison: http://download.microsoft.com/download/D/F/8/DF89D22D-39C8-4728-A990-3BD4467891B7/HighPerformanceSQLServerWorkloadsOnHyper-V_Final.docx
0
 
LVL 1

Author Comment

by:hefterr
ID: 39195812
@didnthaveaname
I personally like 64 bit vs 32 bit for the simple fact that large memory support is native.

I understand this.  But sometimes there are quirky problems with the 64 bit versions.
0
 
LVL 8

Expert Comment

by:didnthaveaname
ID: 39195819
http://download.microsoft.com/download/0/E/8/0E812734-4EC1-4D23-A1F5-0627B07A7484/SQL2008inHyperV2008.pdf - sorry, I'm replying off my phone and had the wrong URL in my clipboard, though I suspect the other is useful as well.  Also, I'm not sure about the complexity of your environment, but I have yet to run across any quirks. That said, we migrated from 2005 64 bit, so there may be more potential for quirkiness in your case. I haven't investigated enough to comfortably make a statement either way.
0
 
LVL 1

Author Closing Comment

by:hefterr
ID: 39202034
Thanks for your help.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
LTrim & Double Space Correction 5 40
backup job space check 4 42
VB.net Duplicating a table - primary key not created 3 31
SQL - Simple Pivot query 8 13
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question