Move SQL 6.5 db to SQL 7.0 9

[jballum]

Hello all,

I was wondering if anyone could suggest the best way to migrate a 6.5 database to 7.0?

Or if you could point me to a FAQ or something similar because I know I have seen this before.

Thanks

JB

 

[fluteplr]

The easiest way is to upgrade the 6.5 server to 7.0 which will automatically upgrade the databases. Other options are to script the database on the 6.5 server, run the script on the 7.0 server, make any changes you need and then use DTS from the 7.0 side to move the data.

 

[jballum]

Upgrading the 6.5 SQL Server to 7.0 is not an option. I have to move an existing 6.5 database on one server to a server with 7.0 on it.

As for the other way (scripting the structure then moving the data using DTS). How about all the user information and that stuff? Does this have to be manually put in or can this be scripted correctly as well?

Thanks again.

JB

 

[clong]

Would any of you have a 'heads up' you could give me in converting a sql 6.5 to 7.0? I've heard a few things about 6.5 triggers not necessarily working in 7.0... I'm pretty sure this is due to MS's change from 6.5's Insert/Delete/Update to 7.0's Before/After Insert, Before/After Delete, Before/After Update.

 

[tlbroadbent]

Check the Microsoft web site for these documents and online seminars about upgrading to SQL Server 7.0:

Converting Databases to Microsoft SQL Server 7.0

http://support.microsoft.com/support/sql/content/70papers/convert.asp

INF: Frequently Asked Questions - Conversion

http://support.microsoft.com/support/kb/articles/q195/4/44.asp

Seminar: Upgrading to Microsoft® SQL Server 7.0

http://www.microsoft.com/Seminar/Includes/Seminar.asp?Url=/Seminar/1033/SQLUpgrade/Portal.xml

Terry

http://members.home.net/tlbroadbent/index.htm