Apply OS: Windows, Mac, Linux

Apply Navicat Product: All

Apply Navicat Version No.: Windows version 7.x or above, Mac version 6.x or above, Linux version 11.x or above


To copy table(s) to the current database, you can

  1. Select the table(s) you want to copy.
  2. Drop and drop them to the same table object list pane.
  3. To copy structure only, choose Copy here (Structure only). To copy structure and data, choose Copy here (Structure and Data).

To copy table(s) to another database, you can

  1. Select the table(s) you want to copy.
  2. Drop and drop them to one database node in the connection / navigation pane.
  3. To copy structure only, choose Copy here (Structure only). To copy structure and data, choose Copy here (Structure and Data).

If the source tables are not on the same server as the target database, a Data Transfer window will be shown

Have more questions?
Submit Ticket