Navicat,navicat Advantage, Navicat download

have been studying navicat recently. One of MySQL's GUI tools, I hope friends who are interested in this area can also communicate with me.

Navicat What are the advantages of MySQL with its own tools.

1.MySQL GUI tools include:
MySQL Query Browser
MySQL Administrator
MySQL Migration Toolkit
MySQL System Tray Monitor

MySQL Query Browser The main features of the introduction:
(1) View the MySQL syntax statement syntax, functions, parameters
(2) tags and historical records
(3) Save the query, open the query file *.qbquery
(4) Create DATABASE (schema), table, view, stored procedure/function, delete, edit table, view, copy table structure.
(5) Create a new connection and switch the connection.

MySQL Administrator Main Function Introduction:
(1) Start/stop MySQL service
(2) User connection times, thread
(3) Health Status View:
Connect health Real-time graph view (connection usage, traffic, number of SQL queries)
Memory Health View (Query Cache hitrate,key efficiency)
Status variable view (normal, performance, network, execute command, mix, new variable)
System variable view (normal, connection, SQL, memory, table type, new variable)
(4) Start variable edit
(5) Server, server instance, client information view
(6) Backup and restore the entire database or 1 to multiple tables, scheduled backups.
(7) Catalog (catalog):
Select database creation, edit table (index, foreign key, column, storage engine, character set, password, auto grow, max row, minimum row, etc.), maintenance table (optimization, check, repair), view the selected database
All indexes, creating, deleting views of the selected database, stored procedures.
(8) The server log includes: error log, normal query log, slow query log

Migration Toolkit:
Can replicate databases from Ms Sql,oracle to MySQL
Mysql System Tray Monitor:
Monitor CPU usage, manage MySQL instance, start variable, MySQL service, server log. Set scan interval (1,2,5,10,30 seconds, 1 minutes)
2.
MySQL Workbench is another MySQL tool:
(1) Add EER chart (abbreviation of Extended entity-relationship)
(2) Using the default schema, creating new tables, new views, and other objects
(3) You can import SQL scripts

3.
Navicat has the following advantages over MySQL GUI tools:
1. The latest version of MySQL support, support MySQL database new objects such as events, MySQL GUI tools can not support event objects.
2. Support SSH connection to MySQL server, MySQL GUI tools does not have this feature set
3. SSL secure connection is supported, MySQL GUI tools does not have this feature
4. Back up connection information, MySQL GUI tools can only view connection information and cannot be backed up.
5. Filter records. Intelligent Input Filter conditions, MySQL GUI tools do not have this function.
6. Import Export supports 17 formats (special formats such as SLK,DIF,WK1,WQ1,RTF,MDB,SAV,LDIF).
7. Structure synchronization, data synchronization. MySQL GUI Tools only backup and restore, migrate data between heterogeneous database types.
8. Schedule, create batch job, set task schedule. Create a set of scheduled batch work to plan the execution of one or more periodic, specified start and end dates and times. Batches can be created by objects including queries, report printing, backup, data transfer, data synchronization, import and export. Send a scheduled job email notification, generating a notification email to the recipient you specify, allowing them to obtain the latest planned information. Read directly from the email account that you sent back the results in the plan. MySQL GUI tools only backup and scheduled backups.
9. Report design, print and custom scheduling. MySQL GUI Tools does not have a report.
10. CREATE table/view desktop shortcuts, Mysql GUI Tools does not have this feature.
11. Table Copy (duplicate)/empty (empty)/delete (trancate) all data. Mysql GUI tools only drop table, CREATE table
12. Navicat automatically completes the SQL code, the Nysql GUI does not intelligently enter SQL commands, only provides SQL syntax queries.
13. Server monitoring, state variables and system variables can be viewed not only like MySQL GUI tools, but also editable.

Navicat Product Introduction can refer to:

Http://www.innovatedigital.com/DatabasesTuning/Navicat.shtml

Navicat for msql Download address:

http://knowhow.innovatedigital.com/node/324