April 28, 2010 at 8:07 am
I'm currently running in production an SQL 2000 database and would like to upgrade to 2005, I have serveral DB's to upgrade with the biggest being 250GB (which is not big). I'm also currently using Reporting Services. Would the ideal thing to do is go straight to 2008 instead to 2005? If it's ok to go to 2005 should I do a migration or an Upgrade? and as far as my reports wouldn't it be better to redo them in SharePoint?
I would appreciate any advise, thanks a lot:-)
April 28, 2010 at 11:32 am
At this juncture, I'd go straight to 2008 R2, skip 2005 and 2008 entirely.
As far as the upgrade process, if you can, the safest way to do it is using what's frequently called the "side-by-side" method. This means you create a second server, running 2008 R2, and backup the 2000 database and restore it on to the 2008 system. That will upgrade the database. There are other steps involved, but that's the basics. This method is one of the safest because your existing database isn't touched in any way. Just in case something goes wrong with the upgrade, you can immediately bring the old system back online.
"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
April 28, 2010 at 11:33 am
Unless you will be using Analysis Services and Integration Services extensively, I would save a little money and just upgrade to 2008. I would avoid R2 since the changes there have largely to do with BI. That said, if you are heavy into BI, then upgrade to R2.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply