How to merge the data from two identical Databases to a third target location.
(Assuming schema1.table1 and schema2.table1 are identical table structure)
1. In Toad, go to the Import Wizard (Tools | Import | Import Wizard).
2. Add a query (Select * from schema1.table1).
3. Choose the option "A single new table" for the target.
4. Name the table to indicate this is the merged table.
5. When the new table has been created with the imported data, open the Data Compare tool (Tools | Compare | Compare Data).
6. Set the source as the new table and set the target as schema2.table1.
7. Once the compare has finished, click on the Synchronization Wizard button.
8. Choose the option to "Make target like source" which will merge the records together.
