Navicat is an ideal solution for PostgreSQL administration and development. This all-inclusive PostgreSQL front end provides a powerful graphical interface for databases management, development and maintenance. Easy installation and intuitive interface make it an irreplaceable tool for PostgreSQL on the web or your local desktop. Navicat let you converts Access to PostgreSQL, MS SQL to PostgreSQL, Excel to PostgreSQL, synchronizes and backups database in a snap through helpful wizards.
Major features include Data Modeling Tool, SQL/DDL Script Generation, Database Wide Search, SQL Code Minifier, Visual Query Builder, Import/ Export, Report Builder, Backup/ Restore, SSH and HTTP Tunneling and Data Transfer. Navicat also supports to import data from ODBC, batch job scheduling (create schedule for Import/Export, Data Transfer and saved queries), printing of table structure. It also includes a full featured graphical manager for setting the users and access privileges.
With Navicat Data Modeling Tool, it allows user to create graphical representations of a relational database. The Reverse Engineer in Navicat Data Modeling Tool allows user to create a conceptual model from an existing database and graphically visualize and edit the structure of the database. Or, user can graphically create a conceptual model, and generate a database that supports the model.
In addition to creating conceptual model from database, Navicat Data Modeling also allows user to compare and synchronize between Models and Databases and generate SQL/ DDL Scripts. This new Navicat Database Modeling Tool is added to the Enterprise Editions of Navicat and Navicat Premium.
Another important enhancements made in version 10 includes the introduction of ER Diagram View, the powerful Database Wise Search and SQL Code Minifier. The program is available for Windows, Mac OS X and Linux and supports multiple languages.