Navicat Lite 8.2.14

Major Features:

1. 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  
2. 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    
3. 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  
4. 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  
   • Support SSL secure connection for MySQL and PostgreSQL 8.4 above    
   • Backup connection information  
   • Customize selected MySQL/PostgreSQL databases to work with
5. Data Viewer and Editor
   • Grid view  
   • Form 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    
   • Support of foreign key data selection: locate the available values from the reference table    
   • Filtering Records    
   • Ability to set number of records showing on each page    
6. SQL Processing
   • Visual query/view builder to facilitate the process of building complicated queries  
   • Ability to create parameter queries  
   • Multiple SQL editors with syntax highlighted feature  
   • Code completion for SQL editors  
   • Ability to preview SQL before execution  
   • Support to return multi-resultsets  
   • SQL console    
7. Diversified Import and Export Competence
   • Importing data from ODBC: MSSQL, Oracle etc  
   • Importing data from MS Excel    
   • Importing data from MS Access    
   • Importing data from other file formats : TXT, CSV, XML, DBF etc  
   • Exporting data to MS Excel  
   • Exporting data to MS Access    
   • Exporting data to HTML and PDF  
   • Exporting data to most popular formats: TXT, CSV, XML, DBF etc  
8. Other Data Manipulation Tools
   • Data transfer (Same or cross server type)  
   • Transferring data to SQL script as INSERT statement  
   • Transferring data to a SQL file with designated SQL format and encoding    
   • Data synchronization  
   • Structure synchronization  
9. Backup/Restore for MySQL/PostgreSQL
   • Backing up/restoring database    
   • Restoring database with chosen database objects    
   • Converting backup file into SQL script  
   • Compressing/Decompressing Backup files  
10. Schedule for Batch Job
    • Ability to set schedule on backup, query execution, import/export, data transfer and data synchronization  
    • Ability to run profiles from different servers in a single schedule job    
    • Schedule report printing    
    • Schedule to print report to files: PDF, Excel, HTML etc  
    • Sending notification e-mail for schedule task  
    • Ability to attach Export Wizard/Report result files in Batch Job notification email
11. Server Security and Maintenance Services
    • Visual user manager to administer users, groups (roles) and privileges  
    • Maintance database/schema objects tables    
    • Server Monitor to view system variables and server status information  
12. Report Management Tools
    • Report Builder  
    • Report Viewer    
13. Other Useful Features
    • Backing up schema/table to SQL script    
    • Executing SQL script  
    • Duplicate/empty/ truncate tables  
    • Create table/view shortcut on desktop  
    • Print schema/table Structure  
    • Support of docking/tab windows    
    • Support of virtual grouping: provide logical organization over connections and objects    
    • 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

Enhancements:

• Improvements:
• • "Exceed package size..." error will now occur to remind you to enlarge the max_allowed_packet variable if the records larger than the maximum packet size setting when running Data Synchronisation for MySQl server.
  • Report Builder now accepts datetime function for MySQL server.
  • PostgreSQL "bytea" data type will now being exported as E'...' in text-base file.
• Bug Fixes:
• • "Property cannot be found" error occured when importing Access file with datatype that may involve decimal places info, e.g.currecy, number, floating point value.
  • BLOB data in text file was unable to import successfully.
  • SQL statements exported from Export Wizard was exported incorrectly.
  • The newly added field (without labelling) would be deleted when clicked "Move Up" button in Table Designer.
  • "List index out of bound" error occured when using an account, which did not have enough privileges, to open MySQL Stored Procedure/Function.
  • Crashed when running "SELECT ctid FROM table" in PostgreSQL server.
  • "Access Violation" error occured when exporting data to Access file if using HTTP Tunnel connection.

Requirements:

• Microsoft Windows 2000, XP, Vista, Server 2003, Server 2008, Windows 7
• 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