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!
>

Microsoft.Jet.OLEDB.4.0" has not been registered

I'm trying to import an access database into a sql express database (32 bit system) and get the following error

Msg 7403, Level 16, State 1, Line 1

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

my script is as follows

SELECT *

FROM OPENDATASOURCE(

'Microsoft.Jet.OLEDB.4.0',

'Data Source="k:\armycwy.mdb";

User ID=Admin;Password='

)...CWAM_ROSTER

Anyone got an idea what is wrong?

TIA

Kevin

I noticed you mentioned 32-bit: is everything 32-bit - i.e. tha machine, Windows, and SQL Express, or is something perhaps 64-bit? We saw similar issues if running 32-bit SQL Server/SQL Express on a 64-bit machine (or vice versa).

What is the Windows version - e.g., XP, Winwdows Server 2000, 2003, etc.?

|||

hi kevin,

pleas try downloading and installing the latest driver

found on this site

http://msdn.microsoft.com/data/mdac/downloads/default.aspx

Joey