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 |
|
Bishop609
Starting Member
2 Posts |
 Posted - 2010-01-21 : 15:21:17
|
| Hello all,I have a working version of SQL 2000 (32 bit) with 13 databases running on a physical server - running on Server 2003.We would like to upgrade this version of SQL 2000 32 bit, to SQL 2005 64 bit... and then transfer to a virtual machine.Can we upgrade 2000 x32 (and its databases) to 2005 x32, and then export/import the databases to an already installed version of 2005 x64, and have the databases work? Even though they are coming from a 32 bit version of SQL?Can anyone recommend a good process to complete this upgrade?Thank you very much for your help.~B |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-21 : 15:32:22
|
| just upgrade them straight to SQL 2005 x64. The intermediate step is wholly unnecessary.when moving to a VM, you'll want to be sure you understand how much RAM/CPU and I/O resources you'll need and that it will be available. also network bandwidth to the VM (as you'll potentially be sharing the NIC with other VMs).you can restore all of your SQL 2000 backups to the 2005 x64 VM, and do all the testing you need without ever shutting off your current servers. |
 |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2010-01-21 : 18:24:09
|
| If your Windows 2003 is X64, you can directly install SQL 2005 x64 bits, backup/restore from SQL 2000 SP4. There are some pre and post migration tasks you need to take care of as part of any upgrade. Search for SQL 2005 Upgrade Technical Reference Guide and you will find all the steps (and some with code) about pre/post migration tasks.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
Bishop609
Starting Member
2 Posts |
Posted - 2010-01-22 : 10:33:24
|
| I thank both of you for your answers. This has helped me to build, and submit my upgrade path. Thanks,~B |
|
|
|
May Chan
Starting Member
6 Posts |
Posted - 2010-01-23 : 12:08:54
|
| "The upgrade to SQL Server 2005 from 2000 was a smooth transition," adds Alan ... A primary reason for moving to the x64 platform might be if your current _____________http://www.microsoftoffice-2010.com/ |
|
|
|
|
|
|
2000 to 2005 & Upgrade to x64 Virtual