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

Apply Navicat Version No.: All

If two tables are in the server, you can employ Data Synchronization to merge the tables.

 

Version 11.2 or below

1. In the General tab, choose one table as Source Table and another as Target Table.
2. In the Advanced Tab, uncheck Delete records and click Start.
3. The target table will become the resulted table after merging.

 

Version 12 or above

1. In the Options tab / window, uncheck Delete records / Delete and click Next.
2. Choose one table as Source and another as Target, and click Next.
3. Click Deploy / Next.
4. Click Execute / Start.
5. 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.