Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL-Server 6.0 to 6.5
Message
From
01/05/1998 09:26:10
 
 
To
30/04/1998 09:03:45
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00095951
Message ID:
00096258
Views:
17
>Did anybody move SQL 6.0 database to 6.5? What steps should be taken from DBA standpoint?
>TIA.

Ed,

If you just want to move the database, DUMP it to tape (or file). 6.5 will load it. After it's loaded you'll have to run a program called chkupg65.exe. It will check for SP source in SYSCOMMENTS and reserve work conflicts.

Most importantly is that the new database MUST be created using the same fragements that the original was. Use sp_help_revdatabase to create a script that contains the correct fragements.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform