RoSoftDownload Editor's Review :
Publisher's Description:
From PremiumSoft CyberTech Ltd.
Navicat Premium is an ideal solution for MySQL, SQLite, SQL Server, Oracle and PostgreSQL administration and development. This is an all-inclusive database front end provides a powerful graphical interface for databases management and maintenance. Easy installation and intuitive interface make it an irreplaceable tool for MySQL, SQLite, SQL Server, Oracle and PostgreSQL on the web or your local desktop.
With different connection established, Navicat Premium is an ALL-IN-ONE application to manage your MySQL, SQLite, SQL Server, Oracle and PostgreSQL databases. It lets you transfer data between MySQL, SQLite, SQL Server, Oracle and PostgreSQL and run Batch job for different databases at a specific time. Other features include Import/ Export Wizard, Query Builder, Report Builder, Data Synchronization, Backup, Job Scheduler and more.
Navicat Premium 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. Navicat version 9.1 supports Microsoft SQL Server (2000 to 2008R2), PostgreSQL Server 9.0, MySQL Server 5.5, cross data transfer between SQL Server, MySQL, Oracle, PostgreSQL and SQLite.
Navicat is the number 1 MySQL database administration shareware in Download.com with over 2,000,000 downloads.Some of the users including Sony Music, Intel, Kodak, FedEx, KPMG Consulting, Ericsson, Siemens AG, Yahoo!, NTT DoCoMo (Japan), Hitachi (Japan), Imation, Lexmark, Cisco Systems, RSA Security, Avis (Europe), U.S. Department of Energy, UPS, Disney, Oxford University, Harvard University, NASA Space Flight Center, MIT, Michigan State University, University of Michigan, ...Navicat delivers a personal experience, simplifying the way you work. The program is available for Windows, Mac OS X and Linux and supports multiple languages.
Latest MySQL Versions Support
* Support of MySQL versions from 3.21 or above.
* Support all MySQL objects: tables, views, stored procedures/functions and events.
* Support all subobjects: fields, indices, foreign keys and triggers.
* Support of partitioning.
* Support of character set and unicode.
Latest SQL Server Versions Support
* Support SQL Server 2000 or above.
* Support all SQL Server objects: tables, views and functions.
* Support all subobjects: fields, indexes, foreign keys, uniques, checks and triggers.
* Managing linked servers, server triggers.
* Managing assemblies, partition functions, partition schemes and database triggers.
* Managing indexes, synonyms and triggers.
* Support of character set and unicode.
All SQLite Versions Support
* Support of SQLite 2 and 3.
* Support all SQLite objects: tables and views.
* Support all subobjects: triggers and indices.
* Support of character set and unicode.
Latest Oracle Versions Support
* Support Oracle Servers 8.1 or above.
* Support all Oracle objects: tables (Normal, External and Index Organized), views, procedures/functions.
* Support all subobjects: fields, indices, foreign keys, uniques, checks and triggers.
* Managing directories, tablespaces, public database links and public synonyms.
* Managing database links, indices, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, types, xml schema and recycle bin.
* Support of physical attributes.
* Support of character set and unicode.
Latest PostgreSQL Versions Support
* Support PostgreSQL Servers 7.3 or above.
* Support all PostgreSQL objects: tables, views and functions.
* Support all subobjects: fields, indices, foreign keys, uniques, checks, rules and triggers.
* Managing tablespace, cast and languages.
* Managing aggregates, conversions, domains, trigger functions, operators and classes, sequences and types.
* Support of character set and unicode.
Changelog for this release:
Major New Features:
- Data Modeling Tools
- ER Diagram view
- SQL Minifier
- Database Wide Search
Improvements:
- Ability to run transaction backup for MySQL database (InnoDB only)
- Added object list in Query Editor
- Added DDL tab in Object Information