Geting SQL 7.0 db from SQL 6.5 db

[ragpark]

How to convert it into a SQL 7.0 database.

1. If I use SQL Upgrade wizard it is giving fallowing errors -

"SQL Server doesnot exists or access denied ConnectionOpen(Connect())"
and
"An error occured while trying to query @@Servername on
'Server_Name', please make sure that this is not null"

2. I can not do Import data from SQL7 becase I am geting only tables but not Userdefined datatype, veiws and SPs.

3. I was not able to restore also sql 6.5 back up file(*.dat) to sql 7 by using restore option.

If there any option is there please let me know.

Thanx
Raghu

 

[tlbroadbent]

1) SQL 6.5 must still be installed on the server for the upgrade to work. Check in the sysservers table to make sure the server is named.

Select srvname from sysservers

If srvname is null set it to the proper name with

sp_addserver sql_server_name, local

2) I don't understand. How are you importing?

3) You cannot restore SQL 6.5 backups to SQL 7. Restore to SQL 6.5 and upgrade to SQL 7.

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.