Copy database from remote server(6.5) to local server(7.0)

[pamelee]

I try to copy database from remote SQL Server(6.5) to our local
SQL Server(7.0). I try this way: First, in Enterprice Manager,
I try "NEW SQL SERVER REGISTRATION" using "Register SQL
Server wizard". The remote server give me the IP, login name
and password. then, I try connect option by "login using
SQL Server". But I got message say:"specialted server not found,
Connection open,create file". some times say:"client server access
denied..." some times say:"timeout". What's going on here?
So, I can not get going on with "Import data wizard".

Does anyone know how to solve this problem? Any answer would be of great assistance!

Thanks

[Craig]

You cannot connect to a 6.5 server from the 7.0 EM, nor should you use DTS to transfer the database.

Use upgrade wizard to upgrade the database from 6.5 to 7.0 per MS.....


------------
pamelee at 5/26/00 9:55:27 AM

I try to copy database from remote SQL Server(6.5) to our local
SQL Server(7.0). I try this way: First, in Enterprice Manager,
I try "NEW SQL SERVER REGISTRATION" using "Register SQL
Server wizard". The remote server give me the IP, login name
and password. then, I try connect option by "login using
SQL Server". But I got message say:"specialted server not found,
Connection open,create file". some times say:"client server access
denied..." some times say:"timeout". What's going on here?
So, I can not get going on with "Import data wizard".

Does anyone know how to solve this problem? Any answer would be of great assistance!

Thanks