Navicat Lite for MySQL 8.1.19

Navicat Lite for MySQL 8.1.19 is such a useful tool which is designed to help users with task of managing and maintaining database.

Navicat Lite is an ideal solution for MySQL administration and development. This is an all-inclusive MySQL front end provides a powerful graphical interface for databases management and maintenance. Easy installation and intuitive interface make it an irreplaceable tool for mysql on the web or your local desktop.

Navicat Lite supports all versions of MySQL and HTTP/ SSH Tunneling. 30 days demo version lets you convert Access to MySQL, MS SQL to MySQL, Excel to MySQL, synchronizes and backups database in a snap through helpful wizards. Major features of Navicat full version include Visual Query Builder, Import/ Export, Report Builder, Backup/ Restore and Data Transfer. Navicat also supports to import data from ODBC, batch job scheduling (create schedule for Import/Export, Data Transfer and saved queries), printing of table structure.

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
   • 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
   • Data synchronization
   • Structure synchronization
7. Backup/Restore
   • Backing up/restoring database
   • Restoring database with chosen database objects
   • Converting backup file into SQL script
   • 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
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

 Enhancements:

1. Added keyboard interactive authentication for SSH.
2. Adjusted the AutoFill from picklist behavior for Grid View.
3. Supported to import Visual Foxpro memo fields to tinytext/blob.
4. Bug Fixes:
   • Fixed export excel spreadsheet with datetime was set to 0.
   • Fixed Move up/Move Down issue in Table Designer.
   • Fixed ampersand not show in Memo view.
   • Employed the last dataset for report when multi-dataset.
   • No need validate the expiry date while using SSL.