Posted by andrew on 11/22/05 12:54

I have two databases with multiple tables. Same tables same fileds.

Both databases contain records, but they should not match each other.

(I will run a report for matches before this and delete any data that
is not current to ensure this is the case)

How do I go about moving data from one of the databases to the other in
order to create a single database with all the data? Unfortunately my
SQL is limited and I cannot image how I would work around the unique
ids. Append or update maybe?

Thanks in advance

Andrew

[Back to original message]