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.

Navicat Essentials is available for three platforms - Microsoft Windows, Mac OS X and Linux. It can connect you to local/remote server, providing several utilities such as SQL editors, import/export, dump/execute SQL scripts and Server Monitor to facilitate the process of data maintenance.

System Requirements:

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 * 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.

• 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.

• 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.

We offer a 30-day fully functional free trial of Navicat, to download, please visit: Download Center