Hi All

I want to transfer the data from one db to the other db for the same table which exists on both
the sides. Can one please let me know about what are the best steps to follow using the DTS packages.

1. Create Source DB connection --- Copy the contents to file --- using the file copy the contents to dest D

is there any process directly one db to other db without any intermediate data storage

Thanks in advance
Roopesh.

use a SQL TASK
copy the data from the first table into a newly created table
copy the data from the second table into a newly created table

use an insert into firsttable
select col1, col2, ... from newlycreated2

insert into secondtable
select col1, col2, ... from newlycreated1

drop the tables you where using, you might consider using temporary tables
as well.



--
Dandy Weyn, Belgium
MCSE, MCSA, MCDBA, MCT

http://www.dandyman.net

Check my SQL Server resource pages (currently under construction)
http://www.dandyman.net/sql


"Roopesh" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Hi Dandy

Thanks for the suggestion, but a small issue, the transfer of data should be happened from one db in
one system to the other db in the different system. But the similar tables will be maintained with out any
constraints , some thing it is similar to the taking back up of existing db , for the data which is not mostl
required. In this scenario what is best solution

Regards
Roopesh

Hi Roopesh,

Use DTS package option from Enterprise manager

1. Create a souce connection (select Source server and database)
2. Create a Destination connection 9Select Dest server and database)
3. From the task list select the "Data Transformation task" , Mouse click on
source and destination
4. After assigning the data transformation task, double click above that
and go to transformation , there you can select the
souce and destination table.
5. Execute the package

Thsi will copy the data from source server to destination server ( Even you
can filter the data while transferring)

Thanks
Hari
MCDBA


"Roopesh" <anonymous (AT) discussions (DOT) microsoft.com> wrote