Migrating Data from SQL 7 - 2000

Can someone please tell me how I export a Database from an SQL 7 server and
import it onto a new SQL 2000 server?
I need to export the database to a file as the 2 servers aren't on the same
network.
Thanks for any advice!SQL 2000 can restore dumps taken in SQL 7.
--
HTH
Ryan Waight, MCDBA, MCSE
"MyATiX" <myatix_at_hotmail.com> wrote in message
news:%2380yx$ikDHA.2060@.tk2msftngp13.phx.gbl...
> Can someone please tell me how I export a Database from an SQL 7 server
and
> import it onto a new SQL 2000 server?
> I need to export the database to a file as the 2 servers aren't on the
same
> network.
> Thanks for any advice!
>|||Hi
SQL7 database can be restored from a backup or attached using sp_attach_db
on a SQL2000 database server. You may be able to FTP the files if you can
not use a UNC address for either a file copy or the backup destination
(probably not advisable anyhow!).
Failing that you may have to write your backup/database files to CD. If that
is the case make sure that the readonly attribute is removed on copying them
to the destination server.
John
"MyATiX" <myatix_at_hotmail.com> wrote in message
news:%2380yx$ikDHA.2060@.tk2msftngp13.phx.gbl...
> Can someone please tell me how I export a Database from an SQL 7 server
and
> import it onto a new SQL 2000 server?
> I need to export the database to a file as the 2 servers aren't on the
same
> network.
> Thanks for any advice!
>