May 26, 2008 at 1:42 pm
hi All
if a client has not made the move to SQL Server 2005 yet, and with SQL Server 2000 support finished now, would it be better to upgrade/migrate to SQL Server 2008?
Has anyone done it?
thanks
May 27, 2008 at 6:34 am
Since 2008 hasn't been released yet, I wouldn't suggest making that migration now. But since it's supposed to be released in August (assuming they don't slip again), if you can wait, yes, I'd recommend just skipping 2005 and going for 2008. Internally where I work, we're making plans for some of our 2000 systems to upgrade them to 2008.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 27, 2008 at 9:09 am
Hi Jon
There were so many new futures that you can use on 2008, i just migrated into 2005 from 2000, i personally would wait atleast 6 months after a release and test it on a developement server and then migrate it.
Cheers
May 28, 2008 at 4:18 am
The reality is that if your client has not already started on a SQL Server 2005 migration project, it will not go live until after SQL Server 2008 is available. The timescales are just too tight.
In this situation, my advise is to plan for a migration direct to SQL Server 2008. You can get the CTP now and start work, but do not plan to go live until after SQL Server 2008 is RTM. Tell your users you plan to go live 4Q 2008 (or even 1Q 2009) to avoid being caught by any slippage in te RTM date.
You will obviously be aware that RTM code often is not as stable as SP1 code, but if the functionality your installation uses is stable then you should be good to go, otherwise you will need to wait for a fix. There are likely to be a few CU releases before SP1 gets released.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
May 28, 2008 at 2:09 pm
thanks for the input all.
at this stage I'm not sure that the client will wait till 2008, but its something I had to explore.
What is the typical time frame for support to be retired. Like 2000 has had support retired, how long before 2005 will have support retired? - 2010?
The will ask me if they continue to upgrade to 2005 - how much time will they have before being forced to go to 2008?
May 29, 2008 at 5:15 am
Here's Microsoft's Life Cycle Support page. Here's the SQL Server 2005 page. We've got to 2011. Which isn't that far off.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply