How to merge two tables that have same table structure?
updated at
Apply OS: Windows, macOS, Linux
Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for Oracle, Navicat for SQL Server, Navicat for SQLite, Navicat for MariaDB, Navicat Premium
If two tables are in the server, you can employ Data Synchronization to merge the tables.
- In the Options window, uncheck Delete records and click Next.
- Choose one table as Source and another as Target, and click Next.
- Click Compare & Preview.
- Click Next.
- 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.
Have more questions?
-
Support
-
About Us