DTS problem

艾丽茜思

Database 1 has table A and database 2 also has table A. The two tables are exactly the same.

I now want to use DTS (no trigger, no coverage) to insert the data in table A of database 1 into table A of database 2, only insert different data, the same is not inserted, how to do it :)

我是杀人狂

select * into b library: table
from a library: table

wgfxman

It is recommended to first DTS to temporary table B, and then according to the data required by B INSERT

我是杀人狂

select * into b library: table
from a library: table where not exists(select * from b library: table)

艾丽茜思

For example: database 1: table A; there are records 1,2,3
     Database 2: Table A; there are records 3, 4, 5, 6
After importing Table A of Database 1 into Table A of Database 2, the results obtained are: 1, 2, 3, 4, 5, 6
3 can not be repeated

dream88

select * into b library: table
from a library: table a where a.id<> b library: table. id

艾丽茜思

Can you directly operate DTS without writing SQL statements?

wsmyth

This is obviously not suitable for DTS! ! ! , Insert ... select ... is more appropriate

艾丽茜思

Now whether he is suitable or not, I just want to know if it can be achieved