Navicat Essentials

Navicat Essentials is a compact version of Navicat which provides basic and necessary features you will need to perform simple administration on a database. It supports the latest features including Trigger, Function, View, and it also comes with an Import/Export tool which allow user to import and export data from plain text file formats including TXT, CSV and XML.

Navicat Essentials is for Commercial use. Currently, Navicat Essentials is available for MySQL, SQL Server, PostgreSQL, Oracle and SQLite databases. If you need to administer all the above database servers at the same time, there is also Navicat Premium Essentials which allows you to access multiple database servers within one single application.

Latest MySQL Versions Support

• Support of MySQL versions from 3.21 or above.
• Support of Drizzle, OurDelta, Percona Server and MariaDB.
• 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 * Only available for two platforms - Microsoft Windows and Mac OS X.

• Support SQL Server 2000 or above.
• Support SQL Azure.
• 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. * Mac OS X Edition starts from Oracle 8.1.7
• 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.

System Requirements:

• Microsoft Windows XP SP2, Vista, Server 2003, Server 2008, Windows 7, Windows 8
• Pentium II processor or above
• Hard-disk space vary depending on installation. Full installation requires 65 MB of available hard-disk space