Navicat Lite 8.2.20


Navicat Lite 8.2.20 | 20.1MB

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 unicode

Oracle 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 unicode

PostgreSQL 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 unicode

Connection 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 with

Data 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 page

SQL 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 console

Server Security and Maintenance Services:
- Visual user manager to administer users, groups (roles) and privileges
- Maintance database/schema objects tables

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

Download