Moving data from one database to another

[smileydba]

Another Newbie Q

Old Database-->table/data--->Move into new database--->table

So basically, what we want is basically, the old database has some data we want to move to the new database. But here is the kicker, the new database already has data in the table we want to move data to. So basically, is there a scripts that does kinda the following,

if a column matchs between the old table and new table,
skip
but if the column from the old table isent in the new,
Add

I see that DTS could do this, but could TSQL do this?? And if so, what would the code be.

Rob W.

 

[smileydba]

Also, basically, dont want any duplicates or the old data over writing the new data.


Rob W.

 

[TimBiesiek]

You could simply add all data from the old table to the new, and then generate a script to remove all duplicates....

 

[smileydba]

Ok, if that is done, how would I write up the Update statement to where the old data(the data that was passed over by the old database) would be deleted instead of the new data?


Rob W.

 

[TimBiesiek]

Hmm, yes, good point....

Perhaps add a column which states which DB the data is from, and if there are duplicates, delete all the duplicates where NewColumn = Old?