October 29, 2008 at 2:26 pm
Has any one migrated a 6.5 SQL-Server database successfully to a 2000 or 2005 SQL-Server? IF you have could you please help with some information I could use? I am a newbie with SQL-Server.
October 29, 2008 at 9:24 pm
I haven't migrated from SQL 6.5 to SQL 2000 or SQL 2005 but I have done it to SQL 7.
A little background first...the physical structures used by SQL Server for data storage changed very significantly between SQL 6.5 and SQL 7. The changes are actually so significant that the migration strategy is
1. script out all database objects
2. use that script to create a new database (SQL 7 or 2000 or 2005)
3. migrate the data (using DTS or SSIS)
In the migration from 6.5 to 7, this was done for you during the installation. I am not sure what the upgrade to 2000 or 2005 does automatically for you but this should be covered in the documentation that Microsoft supplies.
November 4, 2008 at 4:48 am
To migrate from SQL 6.5 to 2005, you will have to first migrate to either sql 7 or 2000. Once done, run the upgrade advisor for 2005 which will analyse your databases and will come out with recommendations/suggestions to avoind any complications during/after migration. Resolve the issues (either before or after upgrade).
For migration strategies, refer to microsoft site which gives you different ways to migrate.
HTH,
Sanjay
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply