Navicat (MySQL GUI) 8.2.15

Navicat (MySQL GUI) 8.2.15 offers users a simple yet effective MySQL database management tool, which can convert XML, CSV, MS Excel, MS Access, and popular data formats to MySQL databases, eliminating time-consuming data entry and the errors that accompany it. Other useful major features include Import and Export wizard, Unicode support, HTTP/SSH Tunnel, Batch Job Scheduling, Data Synchronization, Data Transfer, Visual Query Builder, and Visual Report Builder. Navicat features importing data from ODBC and batch job scheduling.

Major Features:

1. MySQL Objects Management
   • Support MySQL servers 3.21 or above  
   • Create / drop databases    
   • Support all MySQL objects: tables, views, stored procedures/functions and events
   • Support all subobjects: fields, indices, foreign keys and triggers    
   • Support of character set and unicode    
2. Connection Management and Navigation
   • Multiple local/remote MySQL server connections  
   • Connection to MySQL Server through SSH  
   • Connection to MySQL Server through HTTP    
   • Support SSL secure connection    
   • Keep connection alive    
   • Backup connection informations    
   • Customize selected databases to work with    
3. Data Viewer and Editor
   • Grid view    
   • Form view    
   • Text, Hex and BLOB viewer/editor    
   • Copying and pasting selected records    
   • Customize display formats    
   • Incremental search, sorting and formatting table grid    
   • Support of raw mode edit: apply MySQL 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    
4. 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  
5. 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    
6. Other Data Manipulation Tools
   • Data transfer      
   • Transfering data to SQL script as INSERT statement  
   • Transferring data to a SQL file with designated SQL format and encoding  
   • Data synchronization    
   • Structure synchronization    
7. Backup/Restore
   • Backing up/restoring database    
   • Restoring database with chosen database objects    
   • Converting backup file into SQL script  
   • Compressing/Decompressing Backup files    
   • Backing up database/table to SQL script  
   • Executing SQL script  
8. Schedule for Batch Job
   • Ability to set schedule on backup, query execution, import/export, data transfer and data synchronization    
   • 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    
9. Server Security and Maintenance Services
   • Visual user manager to administer users and privileges  
   • Ability to duplicate user  
   • Analyzing, checking, optimizing and repairing tables  
   • Server Monitor to view and change system variables, to view server status information  
10. Report Management Tools
    • Report Builder    
    • Report Viewer  
11. Other Useful Features
    • Duplicate/empty/ truncate tables  
    • Create table/view shortcut on desktop  
    • Print database/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:

• Bug Fixes: "Truncate Table" function did not work with multiple tables 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