Link to home
Start Free TrialLog in
Avatar of hefterr
hefterrFlag for United States of America

asked on

Upgrade of SQL Server 2005

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
Avatar of Brian Crowe
Brian Crowe
Flag of United States of America image

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.
Avatar of hefterr

ASKER

How painful is the upgrade to 2012?  Do you think the upgrade to 2012 is the same effort as to 2012 or 2008?
SOLUTION
Avatar of Brian Crowe
Brian Crowe
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of hefterr

ASKER

We are not using CLR procedures.  I assume there still is a Management Studio and it has not been revamped too much?
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.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of hefterr

ASKER

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.
Avatar of didnthaveaname
didnthaveaname

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
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
Avatar of hefterr

ASKER

@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.
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.
Avatar of hefterr

ASKER

Thanks for your help.