[dba-SQLServer]Migrating from SQL7 to SQL2000

Hi Karen:

You can export all the table structure and stored procedures as a sql file
and load and run on the new server which builds everything then save all the
data to access db. The data can re-imported into the SQL 2000 db in minutes.
If there are two connected boxes with SQL 7 and SQL 2000 it become super
easy; just create a DB on the SQL 2000 box with the same name then export
directly from the SQL 7 straight into SQL 2000. Builds all table, views,
stored procedures, triggers, data etc. while you go for a coffee break.

HTH
Jim

PS about as close to 100% compatible as a operating system can be.

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of
Nicholson, Karen
Sent: Thursday, August 07, 2003 3:00 PM
To: Dba-Sqlserver (E-mail)
Subject: [dba-SQLServer]Migrating from SQL7 to SQL2000


I will be migrating from SQL7 to SQL2000 in the next month or so.  Need
advice - what will be my major problems?  In addition, our company has many
Access 97 databases that are linking and updating (augugughghghg!!!!) to
SQL7.  I am working through those folks to get them into Crystal interfaces
and running stored procedures to update their data, but am concerned about
the compatability if I do not catch all the apps before I migrate.  I
already have contacted those using JAVA to let them know to gear up.

All advice is appreciated.

Thank you.
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com