O'Reilly logo

MySQL Management and Administration with Navicat by Gokhan Ozar

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Direct data transfer between two databases

Another flagship feature of Navicat is its capability to transfer database objects (Tables, Views, Functions, and Events) from one database to another, or to a SQL dump file. The target database can be on the same server or on another server. All you need to do is to have defined a connection to it as described in Chapter 1, Getting Started. The data transfer settings can also be saved as a profile for later retrieval or can be scheduled as a job.

You can start a data transfer process either by choosing Data Transfer... from Tools in the main menu bar, or by right-clicking on a database in the left navigation pane and selecting Data Transfer.... Once you initiate it, you can start specifying the settings ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required