Navicat Essentials is a compact version of Navicat which provides the basic and necessary features you will need to perform simple database administration. It supports the latest features, including Triggers, Functions, Views, and also comes with an Import/Export tool which allows data conversion from plain text formats such as TXT, CSV, and XML. It can also connect you to local/remote servers, providing several utilities such as SQL editors, import/export, and dump/execute SQL scripts, all of which help facilitate data maintenance.
Navicat Essentials is for Commercial use and is available for MySQL, MariaDB, SQL Server, PostgreSQL, Oracle, and SQLite databases. If you need to administer all aforementioned database servers at the same time, there is also Navicat Premium Essentials which allows you to access multiple servers from a single application.
System Requirements
Windows
Microsoft Windows XP SP3, Vista, Windows 7, Windows 8, Windows 8.1, Windows 10, Server 2003, Server 2008, Server 2012
Mac
Mac OS X 10.7 or later
Intel CPU
Linux
Ubuntu 12.04, Ubuntu 14.04, CentOS 6.7, CentOS 7, Fedora 22, Fedora 23, Linux Mint 13, Linux Mint 17.3, openSUSE 13.2, openSUSE 42.1
Latest MySQL Support
In MySQL databases, Navicat Essentials supports:
MySQL 3.21 or above.
Drizzle, OurDelta, Percona Server and MariaDB.
All MySQL objects: tables, views, stored procedures/functions and events.
All subobjects: fields, indexes, foreign keys and triggers.
Partitioning.
Character sets and unicode.
Latest MariaDB Support
In MariaDB databases, Navicat Essentials supports:
MariaDB 5.1 or above.
All MySQL objects: tables, views, stored procedures/functions and events.
All subobjects: fields, indices, foreign keys and triggers.
Extra MariaDB features: new storage engines, microsecond and virtual columns.
Partitioning.
Character sets and unicode.
Latest SQL Server Support * Available Microsoft Windows and Mac OS X.
In SQL Server databases, Navicat Essentials supports:
SQL Server 2000 or above.
SQL Azure.
All SQL Server objects: tables, views, and functions.
All subobjects: fields, indexes, foreign keys, uniques, checks and triggers.
Management of linked servers, server triggers.
Management of partition functions, partition schemes, and database triggers.
Management of indexes, synonyms and triggers.
Character sets and unicode.
Latest SQLite Support
In SQLite databases, Navicat Essentials supports:
SQLite 2 and 3.
All SQLite objects: tables and views.
All subobjects: triggers and indices.
Character sets and unicode.
Latest Oracle Support
In Oracle databases, Navicat Essentials supports:
Oracle Servers 8.1 or above. (* Mac OS X Edition starts from Oracle 8.1.7)
All Oracle objects: tables (Normal, External and Index Organized), views, procedures/functions.
All subobjects: fields, indexes, foreign keys, uniques, checks, and triggers.
Management of directories, tablespaces, public database links, and public synonyms.
Management of database links, indices, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, types, xml schema, and recycle bin.
Management of physical attributes.
Character set and unicode.
Latest PostgreSQL Support
In PostgreSQL databases, Navicat Essentials supports:
PostgreSQL Servers 7.3 or above.
All PostgreSQL objects: tables (Normal and Foreign Table), views, and functions.
All subobjects: fields, indices, foreign keys, uniques, checks, rules, and triggers.
Management of tablespaces, casts, foreign server and language.
Management of aggregates, conversions, domains, trigger functions, operators and classes, sequences, and types.
Character sets and unicode.
© Copyright 2000-2023 COGITO SOFTWARE CO.,LTD. All rights reserved