Moreover, the resulting SQL statement is displayed in the right pane so that you can make modifications, should you make any syntax errors. Whereas version 12 showed all of the query syntax in one statement, version 15 breaks it down into clauses: Select, From, Where, Group By, Having, Order By, and Limit.

Navicat 15 introduces a whole new approach to writing SQL via the new Query Builder. Perhaps even more importantly, Navicat 15's Data Transfer is designed to quickly migrate massive amounts of data - quick enough to accomplish the most complex transfers faster than ever before. You can also limit the number of rows to transfer using custom filters. For instance, you can choose specific fields to transfer and even change the field names. The new design includes an intuitive interface for customizing the fields and specifying the number of rows you wish to transfer. Today, we'll be taking a look at other improvements, including Data Transfer, Query Builder, Data Modeler and more!Īlthough Navicat already supports the transfer of database objects from one database and/or schema to another, or to an sql file, version 15 brings a whole new experience along with a number of new functions to the Data Transfer utility. In the last blog, we explored the Data Visualization feature. In addition to over 100 enhancements, Navicat includes several new features to give you more ways that ever to build, manage, and maintain your databases. It comes packed with numerous improvements and features to address all of your database development and administration needs. Perhaps you've heard that version 15 of Navicat's flagship product, Navicat Premium, was officially released on November 25th. Navicat Premium 15 - the Most Powerful Yet! | Navicat Blog by Robert Gravelle

Navicat premium