Lot of people ask how we going to migrate SQL Server 6.5, SQL Server 7, SQL Server 2000 to SQL Server 2005
If you still using SQL Server 6.5, you can't direct upgrade to SQL Server 2005. You will need to perform 2 step job. First update SQL Server either to SQL 7 or SQL 2000 and then upgrade to SQL 2005
If you using SQL Server 7.0 or SQL server 2000, you have have few method for migration
1. Side by side migration using Copy database wizard
2. Backup and Restore
3. Attached and detach
4. direct upgrade from SQL 2000 to SQL 2005 (Only applicable for SQL 2000)
No comments:
Post a Comment