Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 [replication] partial copy of table to another one

Author  Topic 

Christophe
Starting Member

3 Posts

Posted - 2005-11-17 : 15:30:19
Hi,

I have a database which is replicated hourly from the internal side of the FW to the external side.
I created a new table in the database on the external side.
I then want to copy accross the FW a few fields from the new table (ext)to another table (internal).
Do u know how to do that?

Cheers,
Chris

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-11-26 : 01:32:52
so you have

table1 --> table2 but they have different fields or number of fields?

you can specify a query in your dts instead of choosing the entire object

HTH

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -