Tuesday, October 16, 2007

Thursday, October 4, 2007

Upgrade to SQL Server 2005 or wait for SQL Server 2008?

Since we are fast approaching the SQL Server 2008 public release the question often comes up whether to go ahead and upgrade to SQL Server 2005 or wait until the release of SQL Server 2008. Of course there is no clear cut answer to this question – it depends on many factors however, there is one important thing to consider: Microsoft has put a lot of effort into making the upgrade experience from SQL Server 2005 to SQL Server 2008 as easy and painless as it can possibly be and I don’t think that holds true for migrating from SQL Server 2000 to SQL Server 2008.

So, if you are still in SQL Server 2000 the most efficient and painless approach maybe to upgrade to SQL Server 2005 first and then upgrade from SQL Server 2005 to SQL Server 2008.