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 |
|
BigAl
Starting Member
2 Posts |
 Posted - 2007-11-17 : 16:04:33
|
| I've been tasked to move our production databases on MSSQL 2000 to 2005. I've supported MSSQL since version 6.5 and performed migrations to successor versions.Current Environment is MSSQL 2000 32-bit with current Service Packs.I've performed mock migrations on Test servers upgrading all Production instances simultaneously from MSSQL 2000 to 2005 32-bit. The Test environment is identical to Production minus server name, IP etc. Also I have a separate server with MSSQL 2005 installed where I use the DETACH / ATTACH and BACKUP / RESTORE method for migration / acceptance testing. There are approximately 30 databases totaling 70 GB. This has gone as expected and fairly successful. Vendors have been coordinated with to update code and staff for acceptance testing.I'd prefer going directly to MSSQL 2005 64-bit instead if possible due to memory benefits etc. This is where I'd like some feedback prior to borrowing a 64-bit server for testing.Upgrade options:1. Is it better to migrate from MSSQL 2000 32-bit to 2005 64-bit via: a. DETACH / ATTACH b. BACKUP / RESTORE c. Is one method more advantageous relating to the end result?2. Regarding XP clients, have issues been experienced with the default SQL Server driver or is an alternate recommended for XP clients to connect to a MSSQL 64-bit server databases?3. If you have performed this migration and have relevant experience please pass them along. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-17 : 21:34:24
|
| 1. Both works. The differency is that there is no source db downtime with backup/restore.2. Shouldn't have any problem. |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2007-11-18 : 18:08:49
|
| http://www.aspfree.com/c/a/MS-SQL-Server/Moving-Data-from-SQL-Server-2000-to-SQL-Server-2005/ |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2007-11-18 : 18:11:20
|
| We also are migrating a few databases from 2k to 2005, however we choose not to use the attach/detachAs we are taking advantage of some of the new features of 2005, esp data types. So doing dummy tests all this month.Ehi |
|
|
|
|
|
|
Migration MSSQL 2000 32-bit to MSSQL 2005 64-bit