PresageSolutions
asked on
SQL 2000 to SQL 2005 migration
Dear All,
I have a MS SQL 2000 Database server with 3 databases on it, lots of stored procedures, jobs and DTS packages.
Now -- i want to move all this to MS SQL 2005.
1. Can anyone tell me the quickest and most reliable way to do this ?
2. I have a VB 6.0 application which works with the current MS SQL 2000 database. I know to know Whether an application made in VB 6.0 work with the new sql 20005 database without any problems ? Are there any compability issues between the VB 6.0 apps and MS SQL 2005?
3. Any insights and pitfalls that i should take care while doing the transfer of the databases.
Thanks!
Nitin Khachar
I have a MS SQL 2000 Database server with 3 databases on it, lots of stored procedures, jobs and DTS packages.
Now -- i want to move all this to MS SQL 2005.
1. Can anyone tell me the quickest and most reliable way to do this ?
2. I have a VB 6.0 application which works with the current MS SQL 2000 database. I know to know Whether an application made in VB 6.0 work with the new sql 20005 database without any problems ? Are there any compability issues between the VB 6.0 apps and MS SQL 2005?
3. Any insights and pitfalls that i should take care while doing the transfer of the databases.
Thanks!
Nitin Khachar
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.