| Platforms |
Windows Edition |
Windows Lite
Edition |
Mac OS X
Standard
Edition |
Mac OS X
Lite Edition |
Linux
Standard
Edition |
Linux Lite Edition |
| 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 |
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
|
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 |
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
| Report Management Tools |
| Report Builder |
|
|
|
|
|
|
| Report Viewer |
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
SAP
SolidWorks
Qlik
Microsoft Office
首页 
相关产品
授权相关问题
QQ交谈
在线咨询
渝公网安备 50010702500608号
提供CDN加速/云存储服务
客服热线
