How to merge two tables that have same table structure?
Apply OS: Windows, Mac, Linux
Apply Navicat Product: All
Apply Navicat Version No.: All
If two tables are in the server, you can employ Data Synchronization to merge the tables.
- In General Tab, choose one table as Source Table and another as Target Table.
- In Advanced Tab, uncheck Delete records and click Start.
- The target table will become the resulted table after merging.
If two tables are in other formats (e.g. Excel, text ...), you can import the one file to a new table and then import another to the same table.
Note: The two table structures must be identical.