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 :)
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