The data can also be imported from the ODBC when the data source connection is set up. We can make use of the import wizard to import the data into the database that can be present in various formats. Tool for diversified Manipulation of the database We can get the reports about the comparison of data that can be deployed and further the script can be generated that will list out all the changes that you wish to execute.

All the steps that need to be followed to migrate the data that can involve multiple databases are provided with details and guidelines. If Navicat Premium wasn't that expensive I would have upgraded to that, it would be nice to have SQLite support in Navicat, but than again I don't really need Oracle and PostgreSQL support.The migration of the data becomes easy and fast due to less overhead, Synchronization, and transfer of data, and synchronization of the structure. There are also a couple of other new features (like greatly improved code completion, code folding, SQL beautifier…) but I'm a sucker for nice GUI, so that alone is worth of upgrade for me. There are a lot of standard Mac OS X GUI elements all over the place, better icons, some nice usage of core animations. I've been using Navicat since version 7 and this new version 9 I just upgraded to is the first one that looks and feels like modern native Mac OS X app. Database transfer (copy) from one server to anotherĪnd so far the only app I found for Mac OS X that does these two things is Navicat.Database structure synchronisation (between multiple servers).And there are two things I absolutely need from my MySQL app:

Before I switched to Mac I used SQLyog (great piece of software as well) which is Windows only, so I had to find something similar for Mac OS X. Navicat for MySql is a tool I use on a daily basis, and is in my opinion the best MySQL gui out there.

Navicat mac free