Export/Import data Without DTS 1

[Kristjan]

I have a problem... need to export data from 4 tables in a DB to another DB, but the problem is that both DB not have any connection, the DB1 doesnt have connection with Internet, or Lan etc. We need to carry the data trough zip drive, cd or another etc. We can´t use DTS,
1. We need to make scripts of the data for the 4 tables, and then run in the DB2(Query Analyzer..)?
or
2. How can we update this tables?


Have another problems (relate with) but for the moment we need help with this? which is the best form to do this without DTS?

I search and search, in this excelent forum but the only way i see is trough DTS

by the way: how can i generate data scripts from a table? (without DTS)
---
Tables in both DB's are equals.
the data in one table maybe has too many records.. you know! many records. but for the moment forget this

I realy apreciate all the help

 

[tlbroadbent]

You can use DTS to export the data to a flat file on one server and import from the flat file on the other server. You can also use the BCP utility to export and import data. Bulk Insert can be used for import only. It can import a flat file created by DTS or BCP on the source server. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/programmer.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[Kristjan]

tnx Terry...
but i have another question when i import from that file DTS update the records that the table in DB2 already contain and insert the records etc?
... like when use DTS from DB to DB.
if a records in DB1 are deleted?

ok thats is using DTS, but SQLServer has and sp_ that make that?... for flexibility reasons...

excuse me, what is BCP?

tnx

 

[tlbroadbent]

You can setup the DTS import to delete existing rows or append to the existing rows.

BCP is the Bulk Copy command line utility. It is documented in SQL BOL. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/programmer.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.