Apply OS: Windows, macOS, Linux

Apply Navicat Product: All

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


To copy tables / collections to the current database, you can

  1. Select the tables / collections you want to copy.
  2. Drop and drop them to the same 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 tables / collections 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 / collection are not on the same server as the target database, a Data Transfer window will be shown

Have more questions?
Submit Ticket