I want to export 3 tables in a SQL database with the table definition
and want to then import from this dump into another SQL database where
these tables do not exist.

The tables are - Cust, MatProd, Plant

the database to be exported is - SourcePur and the database these table
have to be created and imported is TargetPur.

Please can you share what utility and what command line options I use
to export these tables into one dump and how to import it back.

If I want to use DTS how can I do it.

Thanks
Karen

Are the database servers on the same network? Can they "talk" to each
other?
You could use DTS to import data from one server. It is a fairly easy
process. Using DTS in this type of basic scenario is pretty
straightforward. You simply import data from a specific source.

--
Keith


<karenmiddleol (AT) yahoo (DOT) com> wrote

Right click on tables--> all tasks-->export data
Then you will get a wizard, set up your source DB and your destination DB,
select the tables hit run and that's it

you can also use BCP to export and import them


http://sqlservercode.blogspot.com/


"karenmiddleol (AT) yahoo (DOT) com" wrote:

DTS or the "bulk copy" command can be used to export the data to a file such
as tab delimited text, MS Access, native, etc.

However, none of these file formats will retain all the table structure
including the exact data type, constraints, triggers, etc. For this, you
will need to use the "Generate Scripts" feature of Enterprise Manager. On
the destination database, run the scripts to re-create empty tables, then
use DTS or bulk copy the files into the appropriate tables.

CREATE TABLE
http://msdn.microsoft.com/library/en...eate2_8g9x.asp
How to generate a script (Enterprise Manager)
http://msdn.microsoft.com/library/en...esign_3qt0.asp
Preparing Data for Importing and Exporting
http://msdn.microsoft.com/library/en...t_bcp_1njt.asp
Copying Data From a Data File to SQL Server
http://msdn.microsoft.com/library/en...t_bcp_4t9u.asp


<karenmiddleol (AT) yahoo (DOT) com> wrote