Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tincupal
Starting Member
24 Posts |
 Posted - 2009-02-20 : 09:37:50
|
| Hello,We have a database server with SQL 2000 and multiple databases and we need to upgrade it to SQL 2005 or SQL 2008. So I have a few questions:1. Should we upgrade to SQL 2005 or SQL 2008? Is SQL 2008 stable?2. Can we upgrade directly from 2000 to 2008 or do we need to go to 2005 and then 2008?3. Can we upgrade in place or would you suggest building a new server and migrating the databases over to the new server?Thanks very much in advance,Al |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-02-20 : 09:51:18
|
| 1. Yes2. 2000 to 2008 will work fine.3. Migrating over. Big diff between 2000 and 2008 and you want to make sure things work before you start using 2008 databases in production when switching over.If you have a lot of DTS packages make sure you read "A LOT" about the issues converting from DTS to SSIS which would be a stumbling block with either version.Mike"oh, that monkey is going to pay" |
 |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-02-21 : 14:58:50
|
| just to add, you need at least SP4 if you want to do inplace upgrade. If you have the bandwidth to purchase new hardware then migrating would be a good option. Hopefully you are already on x64. If not, that should definetely be in the prioritty list. Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2009-02-23 : 23:39:38
|
| 1. Should we upgrade to SQL 2005 or SQL 2008? Is SQL 2008 stable?Ans: There are ups/downs of upgrading to sql 2005 or sql 2008, web is flooded with articles and recommendation whether to upgrade to sql 2005 to jump to sql 2008 directly. a) Going from SQL 2000 to SQl 2008 is a big change for everyone including developers and DBA's are they trained enough to handle this enviornement. b) Two downtime windows are required if you move to sql 2005 than sql 2008. Direct upgrade to sql 2008 would reduce total downtime window depending on inplace/side-by-side upgrade. Stability of platform for your application/enviornment depends on several factors. In general SQL 2008 is stable, I have helped many customers upgrading to sql 2008, they are happy. 2. Can we upgrade directly from 2000 to 2008 or do we need to go to 2005 and then 2008? See above3. Can we upgrade in place or would you suggest building a new server and migrating the databases over to the new server?Ans: You can upgrade inplace. Rwead about in-place and side-by-seid upgrade pros/cons. Why you want to move to a new server? Any issues with existing server? Are you looking for capacity planing? I read your post twice but I don't see you mention about using X-64. How others hpoing you're using x-64? or its just hypothetical. |
|
|
|
mdubey
Posting Yak Master
133 Posts |
Posted - 2009-03-04 : 19:13:48
|
| Here is my 2cents...1) Yes we can go directly from SQL 2000 to SQL 2008. But do you have plan for SQL 2008 (Someone already raised this question.) (Does all dba and developers trained on SQL 2008? Do you have Capacity planning for that? Why your company didn't upgrade to SQL 2005 before SQL 2000 went to SUNSET mode?)2)Good to have to use upgrade advisor on SQL 2000 (Assumming you have 2000 with SP4 and cummulative patches). IMP for DTS to SSIS migration.3) Well it's depend how big your organization and how much they can spend on new hardware. Inplace upgrade would be good if don't have budget otherwise new hardware selection would be best.SQL 2008 SP1 is going to release between april and June2009. Be prepare for the new project planning have to have rollback solution in place in case you need to go back on old version.All the best.ManojMCP, MCTS |
|
|
|
|
|
|
Upgrade to 2005 or 2008?