Upgrading to SQL 200 from version 7.0greenspun.com : LUSENET : SQL Server Database Administration : One Thread
I am due to do an upgrade of our two sql 7 servers to 2000. I have read the white papers etc.. and seen the options for the upgrades, either upgrade the DB's therefore overwriting the existing one and using a named instance. Just wondered if there were any pitfalls I should be aware of really to prepare myself. Also I have a number of ODBC links going to the SQL 7 databases (as they are using Access front ends) Do I need to upgrade the ODBC version from 3.70.06.23 etc..to the 2000 drivers for then to be still able to connect??
Many Thanks in advance of your help
-- Anonymous, June 26, 2001
I found that the upgrade in place (after a backup of course) went without incident.
About the ODBC driver, you should be OK with or without upgrading it. See the KnowledgeBase article, INF: Frequently Asked Questions - SQL Server 2000 - Programming (at http://support.microsoft.com/support/kb/articles/Q260/8/17.ASP) for more details.
-- Anonymous, June 28, 2001
I migrate by importing bases in a fresh installation of 2000 on another server.
I had troubles with triggers that the Web Assistant generated in a database when it was running under 6.5 or 7.0. So I would advise you to remove them before migration.
-- Anonymous, July 08, 2001