Code:
Designed to meet the needs of database administrators, developers, and small and medium businesses,
Navicat is built with an intuitive GUI which lets you create, organize, access and share information in a secure
and easy way.Navicat Lite offers almost the same functions as the Premium version.NOTE:Free for non-commercial use.
Here are some key features of "Navicat Lite":MySQL Objects Management:· Supports MySQL Servers 3.21 or above·
Create / Drop Databases· Support all MySQL objects: tables, views, procedures/functions and events·
Support all subobjects: fields, indices, foreign keys and triggers· Support of partitioning· Support of character
set and unicodeOracle Objects Management:· Supports Oracle Servers 8.1 or above· Create/drop schemas·
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 unicodePostgreSQL Objects Management:· Supports PostgreSQL Servers 7.3 or above·
Create /drop databases and schemas· Support all PostgreSQL objects: tables, views and functions· Support all subobjects:
fields, indices, foreign keys, uniques, checks, rules and triggers· Managing tablespace· Managing cast and languages·
Managing aggregates, conversions, domains, trigger functions, operators and classes, sequences and types·
Support of character set and unicodeConnection Management and Navigation:· Multiple local/remote
MySQL/Oracle/PostgreSQL server connections· Support of Oracle Basic Connection· Support of Oracle TNS Connection·
Connection to MySQL/Oracle/PostgreSQL Server through SSH· Connection to MySQL/PostgreSQL
Server through HTTP· Backup connection information· Customize selected MySQL/PostgreSQL databases
to work withData Viewer and Editor:· Grid view· Text, Hex and BLOB viewer/editor· Oracle BFile viewer/editor·
Copying and pasting selected records· Customize display formats· Incremental search, sorting and formatting table grid·
Ability to show/hide Oracle table ROWID· Support of raw mode edit: apply MySQL/PostgreSQL built-in function·
Ability to set number of records showing on each pageSQL Processing:· Ability to create parameter queries·
Multiple SQL editors with syntax highlighted feature· Ability to preview SQL before execution·
Support to return multi-resultsets· SQL consoleServer Security and Maintenance Services:·
Visual user manager to administer users, groups (roles) and privileges·
Maintance database/schema objects tablesOther Useful Features:· Backing up schema/table to SQL script·
Executing SQL script· Duplicate/empty/ truncate tables· Create table/view shortcut on desktop·
Support of docking/tab windows· Ability to run profile from command line·
Log files: keep track on the actions have been performed in Navicat· Ability to copy Connection Information into
Clipboard Requirements:· Pentium II processor or above· 64 megabytes (MB) of RAM·
Hard-disk space vary depending on installation. Full installation requires 10 MB of available hard-disk space.