I have a system developed using VB6 and SQL 2000. My client want the system running on SQL 2005. Can I have a guideline on how to migrate? Thanks in advance of your support.
DavidFat.
DavidFat.
-
-
You can use the SQL server's Upgrade wizard to upgrade your current SQL server 2000 DB to 2005.
You should notice the new features of SQL server 2005, the 'text' columns can be moved to 'varchar(Max)' , also you should go thru the new error handling features of sql server 2005.
the system tables in 2005 and 2000 are different , so you need to modify your queries in 2000 which refers the system tables
Comment