Navicat Premium 8.1.3

Navicat Premium 8.1.3 is a smart and easy-to-use tool which lets you connect to MySQL, PostgreSQL and Oracle databases simultaneously within a single application, making database administration to multiple kinds of database so easy.

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 and above
   • 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                      
   • SQL console              
7. Diversified Import and Export Competence              
   • Importing data from ODBC: MSSQL, Oracle etc              
   • Importing data from MS Excel                        
   • Importing data from other file formats : TXT, CSV, XML, DBF etc              
   • Exporting data to MS Excel            
     
   • 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                        
   • Converting backup file into SQL script                        
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          
      
    • 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. 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:
• • Compatible with Mac OS X Snow Leopard.
  • Stability improvement on tabbed window.
• Bug Fixes:
• • Indexes could not work if user is not superuser.
  • Import Wizard would be launched if the Data format was not properly set.

Requirements: Mac OS X 10.4 Tiger or 10.5 Leopard