importing the data

[Guest_imported]

hi,
I wanted to know how we could get data from a remote SQL server 7.0 to a local SQL server 2000

 

[Cagliostro]

yes, I did it. John Fill

ivfmd@mail.md

 

[xor]

So how did you do it John?
Is it possible to get the data from a remote SQLServer 2000 db to a local SQLServer 7.0?

xor

http://donnamiller.net/

 

[Cagliostro]

I've added the remote server regystration to my enterprise manager. RClick with mouse on a server in a group in EnterpriseManager and choose that option. John Fill

ivfmd@mail.md

 

[tlbroadbent]

You can use Data Transformation Services (DTS). Start the import/export wizard. Choose the source and dustination servers. Choose the table(s) to transfer.

Link the SQL 7 server to the SQL 2000 Server and use remote queries to move the data.

Export data from SQL 7 with BCP. BCP into SQL 2000.

There are many ways. My preference is DTS for transferring full tables. I use linked servers in some cases for small tables or updates. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it if you have time.