[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3419
  • Last Modified:

SQL Server 2005 vs. 2008

I will be upgrading from SQL Server 2000 within the next couple of months.  I have been debating on which version to go with either 2005 or 2008?  If I go from 2000 to 2008 will there be more problems then if I just went to 2005?  Any suggestions welcome.
Nathan Riley
Nathan Riley
5 Solutions
James MurrellProduct SpecialistCommented:
Personally I would mojust move to 2008. if you move to 2005 when you decide to move to 2008 you will be wondering should you do 2008 or the next version...

a lot of people will wait to upgrade  any release until SP1 is released..

in the end the decision is yours... but i would plan to move to 2008 and miss 2005
You can just migrate to sql 2008. Either 2000 or 2005 you might be facing problems migrating SSIS Packages and SSAS cubes, coz it is totally a different architecture.
     You may want to read the technical document for further information on migration
SQL 2005 is pretty stable at this point with SP3 just having been released in December 2008.. But if you opt for this, then a future upgrade to SQL 2008 will involve purchasing it unless you go for software assurance package which will be pretty expensive.

SQL 2008 is pretty new, but that shouldn't necessarily be an issue as such.. Its really a judgement call on whether to take the plunge or not..

The upgrade would be more or less the same in both I guess..

Raja Jegan RSQL Server DBA & ArchitectCommented:
I suggest you to go for SQL Server 2008 because it has lot more features and functionality in it.

Migrating 2000 -> 2008 shouldn't be any more work than migrating 2000 -> 2005. From the point of view of backwards compatibility and breaking changes the big changes all apply to both. For example: SSIS replaces DTS; new SSAS cube model; BIDS; schema instead of owner; deprecated T-SQL features. 2008 lacks Notification Services, which is now discontinued.

2008 isn't as big a leap in functionality as 2005 was but there are plenty of good reasons to use it:

Upgrade Advisor:

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now