 |
|
|
|
|
왜 고객 센터입니까?
Navicat 고객 센터는 우리로 부터 구입한 모든 라이센스들과 가입들을 나열함으로서, 고객의 전체 주문 내역에 대한 액세스를 제공합니다.
고객의 주문 요약 확인, 라이센스 정보 검색, 유지 보수 가입 확인, 지원 티켓 송부, 계정 정보 수정, 청구서 인쇄 및 기타를 위해 http://customer.navicat.com/kr/ 에 로그인하십시오.
|
|
|
|
|
| |
|
|
홈  제품들 Navicat Essentials Feature Matrix
|
Feature Matrix for Navicat Essentials
Platforms
* ESS: Essentials Edition. |
Win
ESS
|
Mac
ESS
|
Linux
ESS
|
|
MySQL Objects Management
|
|
|
|
| Support MySQL Servers 3.21 or above |
|
|
|
| Support of Drizzle, OurDelta, Percona Server and MariaDB |
|
|
|
| Create / Drop Databases |
|
|
|
| Support all MySQL objects: tables, views, procedures/functions and events |
|
|
|
| Support all subobjects: fields, indexes, foreign keys and triggers |
|
|
|
| Support of partitioning |
|
|
|
| Support of character set and unicode |
|
|
|
|
Oracle Objects Management
|
|
|
|
| Support Oracle Servers 8.1 or above (Mac OS X Edition starts from Oracle 8.1.7) |
|
|
|
| Create/drop schemas |
|
|
|
| Support all Oracle objects: tables (Normal, External and Index Organized), views, procedures/functions |
|
|
|
| Support all subobjects: fields, indexes, foreign keys, uniques, checks and triggers |
|
|
|
| Managing directories, tablespaces, public database links and public synonyms |
|
|
|
| Managing database links, indexes, 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
|
|
|
|
| Support PostgreSQL Servers 7.3 or above |
|
|
|
| Create /drop databases and schemas |
|
|
|
| Support all PostgreSQL objects: tables, views and functions |
|
|
|
| Support all subobjects: fields, indexes, 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 |
|
|
|
|
SQLite Objects Management
|
|
|
|
| Support SQLite 2 and 3 |
|
|
|
| Attach/detach databases |
|
|
|
| Support all SQLite objects: tables and views |
|
|
|
| Support all subobjects: triggers and indexes |
|
|
|
| Support to view master table |
|
|
|
| Support of character set and unicode |
|
|
|
|
SQL Server Objects Management
|
|
|
|
| Support SQL Server 2000 or above |
|
|
|
| Support SQL Azure |
|
|
|
| Create /drop databases and schemas |
|
|
|
| Support all SQL Server objects: tables, views and functions |
|
|
|
| Support all subobjects: fields, indexes, foreign keys, uniques, checks and triggers |
|
|
|
| Managing linked servers, server triggers |
|
|
|
| Managing assemblies, partition functions, partition schemes and database triggers |
|
|
|
| Managing indexes, synonyms and triggers |
|
|
|
| Support of character set and unicode |
|
|
|
|
Connection Management and Navigation
|
|
|
|
| Multiple local/remote server connections |
|
|
|
| Support of Oracle Basic Connection |
|
|
|
| Support of Oracle TNS Connection |
|
|
|
| Support to connect a new or an existing SQLite database |
|
|
|
| Support encrypted SQLite file (wxSQLite3) |
|
|
|
| Connection to MySQL/Oracle/PostgreSQL/SQL Server through SSH |
|
|
|
| Connection to MySQL/PostgreSQL/SQLite through HTTP |
|
|
|
| Support SSL secure connection for MySQL and PostgreSQL 8.4 above |
|
|
|
| Keep connection alive |
|
|
|
| Export/Import connections settings |
|
|
|
| Customize selected MySQL/PostgreSQL databases to work with |
|
|
|
|
Feature Rich Oracle PL/SQL Code Debugger
|
|
|
|
| Support on showing interactive and real-time debugging information |
|
|
|
| Ability to set simple and complex breakpoints |
|
|
|
| Stepping through a function, i.e. Step Into, Step Over and Step Out |
|
|
|
| Inspecting variables and expressions |
|
|
|
| Stack traces |
|
|
|
|
Data Viewer and Editor
|
|
|
|
| UUID/GUID generator for PostgreSQL/SQL Server |
|
|
|
| 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 and SQLite tables ROWID |
|
|
|
| Support of raw mode edit: apply MySQL/PostgreSQL/SQLite/SQL Server 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 |
|
|
|
| Code completion for SQL editors |
|
|
|
| Code outline |
|
|
|
| SQL Code Beautifier/Minifier |
|
|
|
| Multiple SQL editors with syntax highlighted feature |
|
|
|
| Support code folding, highlighted matches words and brackets |
|
|
|
| Copy SQL with quote |
|
|
|
| Word Wrap |
|
|
|
| Zoom In/Out for SQL editors |
|
|
|
| Enhanced find and replace options in SQL editors |
|
|
|
| Ability to preview SQL before execution |
|
|
|
| Support to return multi-resultsets |
|
|
|
| SQL console |
|
|
|
|
Data Modeling Tools
|
|
|
|
| Reverse engineering |
|
|
|
| Support of several diagram notations like Crow's Foot, IDEF1x and UML |
|
|
|
| Ability to create/edit/drop database objects, visually set relationships between them |
|
|
|
| Support of auto layout |
|
|
|
| Support numerous visual customization options like adding vertices, layers, images and notes/labels |
|
|
|
| Zoom In/Out for ER diagram |
|
|
|
| Comparing and synchronizing database/model |
|
|
|
| Generating complex SQL/DDL |
|
|
|
| Multi-page print preview |
|
|
|
| Ability to print the database diagram to PDF file |
|
|
|
| Ability to save the database diagram as a graphic file, i.e. PNG, SVG |
|
|
|
|
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 plain text file formats : TXT, CSV, XML etc |
|
|
|
| Importing data from other file formats : DBF etc |
|
|
|
| Exporting data to MS Excel |
|
|
|
| Exporting data to MS Access |
|
|
|
| Exporting data to HTML |
|
|
|
| Exporting data to plain text file formats: TXT, CSV, XML etc |
|
|
|
| Exporting data to most popular formats: 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/SQLite
|
|
|
|
| Backing up/restoring database |
|
|
|
| Backing up database with chosen database objects |
|
|
|
| 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 |
|
|
|
| Notification email Support SSL/TLS |
|
|
|
|
Server Security and Maintenance Services
|
|
|
|
| Visual user management |
|
|
|
| Visual privilege manager |
|
|
|
| Ability to duplicate user, role, etc |
|
|
|
| Maintance database/schema objects |
|
|
|
| Server Monitor to view and change system variables and server status information |
|
|
|
|
Report Management Tools
|
|
|
|
| Report Builder |
|
|
|
| Report Viewer |
|
|
|
|
Other Useful Features
|
|
|
|
| ER Diagram view |
|
|
|
| Ability to customize connection colorings |
|
|
|
| Support of database wide search |
|
|
|
| Objects search filter |
|
|
|
| Backing up database/schema/table to SQL script |
|
|
|
| Executing SQL script |
|
|
|
| Duplicate/empty/truncate tables |
|
|
|
| Create table/view shortcut on desktop |
|
|
|
| Ability to create Favorites list |
|
|
|
| Ability to set auto-save for Query, Function, etc |
|
|
|
| Print database/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 |
|
|
|
Platforms
*ESS: Essentials Edition. |
Win
ESS
|
Mac
ESS
|
Linux
ESS
|
| MySQL Objects Management |
|
|
|
| Support MySQL Servers 3.21 or above |
|
|
|
| Support of Drizzle, OurDelta, Percona Server and MariaDB |
|
|
|
| Create / Drop Databases |
|
|
|
| Support all MySQL objects: tables, views, stored procedures/functions and events |
|
|
|
| Support all subobjects: fields, indexes, foreign keys and triggers |
|
|
|
| Support of partitioning |
|
|
|
| Support of character set and unicode |
|
|
|
| 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 |
|
|
|
| Export/Import connections settings |
|
|
|
| Customize selected databases to work with |
|
|
|
| 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 |
|
|
|
| SQL Processing |
|
|
|
| Visual query/view builder to facilitate the process of building complicated queries |
|
|
|
| Ability to create parameter queries |
|
|
|
| Code completion for SQL editors |
|
|
|
| SQL Code Beautifier/Minifier |
|
|
|
| Multiple SQL editors with syntax highlighted feature |
|
|
|
| Support code folding, highlighted matches words and brackets |
|
|
|
| Copy SQL with quote |
|
|
|
| Word Wrap |
|
|
|
| Zoom In/Out for SQL editors |
|
|
|
| Enhanced find and replace options in SQL editors |
|
|
|
| Ability to preview SQL before execution |
|
|
|
| Support to return multi-resultsets |
|
|
|
| SQL console |
|
|
|
| Data Modeling Tools |
|
|
|
| Reverse engineering |
|
|
|
| Support of several diagram notations like Crow's Foot, IDEF1x and UML |
|
|
|
| Ability to create/edit/drop database objects, visually set relationships between them |
|
|
|
| Support of auto layout |
|
|
|
| Support numerous visual customization options like adding vertices, layers, images and notes/labels |
|
|
|
| Zoom In/Out for ER diagram |
|
|
|
| Comparing and synchronizing database/model |
|
|
|
| Generating complex SQL/DDL |
|
|
|
| Multi-page print preview |
|
|
|
| Ability to print the database diagram to PDF file |
|
|
|
| Ability to save the database diagram as a graphic file, i.e. PNG, SVG |
|
|
|
| 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 plain text file formats : TXT, CSV, XML etc |
|
|
|
| Importing data from other file formats : DBF etc |
|
|
|
| Exporting data to MS Excel |
|
|
|
| Exporting data to MS Access |
|
|
|
| Exporting data to HTML |
|
|
|
| Exporting data to plain text file formats: TXT, CSV, XML etc |
|
|
|
| Exporting data to most popular formats: DBF etc |
|
|
|
| Other Data Manipulation Tools |
|
|
|
| Data transfer |
|
|
|
| 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 |
|
|
|
| Backing up / restoring database |
|
|
|
| Backing up database with chosen database objects |
|
|
|
| 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 |
|
|
|
| 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 |
|
|
|
| Notification email Support SSL/TLS |
|
|
|
| Server Security and Maintenance Services |
|
|
|
| Visual user management |
|
|
|
| Visual privilege manager |
|
|
|
| Ability to duplicate user |
|
|
|
| Maintance database objects |
|
|
|
| Server Monitor to view and change system variables, to view server status information |
|
|
|
| Report Management Tools |
|
|
|
| Report Builder |
|
|
|
| Report Viewer |
|
|
|
| Other Useful Features |
|
|
|
| ER Diagram view |
|
|
|
| Ability to customize connection colorings |
|
|
|
| Support of database wide search |
|
|
|
| Objects search filter |
|
|
|
| Backing up database/table to SQL script |
|
|
|
| Executing SQL script |
|
|
|
| Duplicate/empty/truncate tables |
|
|
|
| Create table/view shortcut on desktop |
|
|
|
| Ability to create Favorites list |
|
|
|
| Ability to set auto-save for Query, Function, etc |
|
|
|
| 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 |
|
|
|
Platforms
*ESS: Essentials Edition. |
Win
ESS
|
Mac
ESS
|
| SQL Server Objects Management |
|
|
| Support SQL Server 2000 or above |
|
|
| Support SQL Azure |
|
|
| Create /drop databases and schemas |
|
|
| Support all SQL Server objects: tables, views and functions |
|
|
| Support all subobjects: fields, indexes, foreign keys, uniques, checks and triggers |
|
|
| Managing linked servers, server triggers |
|
|
| Managing assemblies, partition functions, partition schemes and database triggers |
|
|
| Managing indexes, synonyms and triggers |
|
|
| Support of character set and unicode |
|
|
| Connection Management and Navigation |
|
|
| Multiple local/remote SQL Server server connections |
|
|
| Connection to SQL Server through SSH |
|
|
| Keep connection alive |
|
|
| Export/Import connections settings |
|
|
| Data Viewer and Editor |
|
|
| UUID/GUID Generator |
|
|
| 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 SQL Server 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 |
|
|
| Code completion for SQL editors |
|
|
| Code outline |
|
|
| SQL Code Beautifier/Minifier |
|
|
| Multiple SQL editors with syntax highlighted feature |
|
|
| Support code folding, highlighted matches words and brackets |
|
|
| Copy SQL with quote |
|
|
| Word Wrap |
|
|
| Zoom In/Out for SQL editors |
|
|
| Enhanced find and replace options in SQL editors |
|
|
| Ability to preview SQL before execution |
|
|
| Support to return multi-resultsets |
|
|
| SQL console |
|
|
| Data Modeling Tools |
|
|
| Reverse engineering |
|
|
| Support of several diagram notations like Crow's Foot, IDEF1x and UML |
|
|
| Ability to create/edit/drop database objects, visually set relationships between them |
|
|
| Support of auto layout |
|
|
| Support numerous visual customization options like adding vertices, layers, images and notes/labels |
|
|
| Zoom In/Out for ER diagram |
|
|
| Comparing and synchronizing database/model |
|
|
| Generating complex SQL/DDL |
|
|
| Multi-page print preview |
|
|
| Ability to print the database diagram to PDF file |
|
|
| Ability to save the database diagram as a graphic file, i.e. PNG, SVG |
|
|
| 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 plain text file formats : TXT, CSV, XML etc |
|
|
| Importing data from other file formats : DBF etc |
|
|
| Exporting data to MS Excel |
|
|
| Exporting data to MS Access |
|
|
| Exporting data to HTML |
|
|
| Exporting data to plain text file formats : TXT, CSV, XML etc |
|
|
| Exporting data to most popular formats: DBF etc |
|
|
| Other Data Manipulation Tools |
|
|
| Data transfer |
|
|
| Transferring data to SQL script as INSERT statement |
|
|
| Transferring data to a SQL file with designated SQL format and encoding |
|
|
| Data synchronization |
|
|
| Structure synchronization |
|
|
| Schedule for Batch Job |
|
|
| Ability to set schedule on 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 |
|
|
| Notification email Support SSL/TLS |
|
|
| Server Security and Maintenance Services |
|
|
| Visual user management |
|
|
| Visual privilege manager |
|
|
| Ability to duplicate user, role, etc |
|
|
| Maintance database/schema objects |
|
|
| Server Monitor to view system variables and server status information |
|
|
| Report Management Tools |
|
|
| Report Builder |
|
|
| Report Viewer |
|
|
| Other Useful Features |
|
|
| ER Diagram view |
|
|
| Ability to customize connection colorings |
|
|
| Support of database wide search |
|
|
| Objects search filter |
|
|
| Backing up schema/table to SQL script |
|
|
| Executing SQL script |
|
|
| Duplicate/empty tables |
|
|
| Create table/view shortcut on desktop |
|
|
| Ability to create Favorites list |
|
|
| Ability to set auto-save for Query, Function, etc |
|
|
| 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 |
|
|
Platforms
*ESS: Essentials Edition. |
Win
ESS
|
Mac
ESS
|
Linux
ESS
|
| SQLite Objects Management |
|
|
|
| Support SQLite 2 and 3 |
|
|
|
| Attach/detach databases |
|
|
|
| Support all SQLite objects: tables and views |
|
|
|
| Support all subobjects: triggers and indexes |
|
|
|
| Support to view master table |
|
|
|
| Support of character set and unicode |
|
|
|
| Connection Management and Navigation |
|
|
|
| Multiple local/remote SQLite database connections |
|
|
|
| Support to connect a new or an existing database |
|
|
|
| Support encrypted SQLite file (wxSQLite3) |
|
|
|
| Connection to SQLite database through HTTP |
|
|
|
| Export/Import connections settings |
|
|
|
| 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 SQLite built-in function |
|
|
|
| Ability to show/hide ROWID |
|
|
|
| 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 |
|
|
|
| Code completion for SQL editors |
|
|
|
| SQL Code Beautifier/Minifier |
|
|
|
| Multiple SQL editors with syntax highlighted feature |
|
|
|
| Support code folding, highlighted matches words and brackets |
|
|
|
| Copy SQL with quote |
|
|
|
| Word Wrap |
|
|
|
| Zoom In/Out for SQL editors |
|
|
|
| Enhanced find and replace options in SQL editors |
|
|
|
| Ability to preview SQL before execution |
|
|
|
| Support to return multi-resultsets |
|
|
|
| SQL Console |
|
|
|
| Data Modeling Tools |
|
|
|
| Reverse engineering |
|
|
|
| Support of several diagram notations like Crow's Foot, IDEF1x and UML |
|
|
|
| Ability to create/edit/drop database objects, visually set relationships between them |
|
|
|
| Support of auto layout |
|
|
|
| Support numerous visual customization options like adding vertices, layers, images and notes/labels |
|
|
|
| Zoom In/Out for ER diagram |
|
|
|
| Comparing and synchronizing database/model |
|
|
|
| Generating complex SQL/DDL |
|
|
|
| Multi-page print preview |
|
|
|
| Ability to print the database diagram to PDF file |
|
|
|
| Ability to save the database diagram as a graphic file, i.e. PNG, SVG |
|
|
|
| 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 plain text file formats : TXT, CSV, XML etc |
|
|
|
| Importing data from other file formats : DBF etc |
|
|
|
| Exporting data to MS Excel |
|
|
|
| Exporting data to MS Access |
|
|
|
| Exporting data to HTML |
|
|
|
| Exporting data to plain text file formats : TXT, CSV, XML etc |
|
|
|
| Exporting data to most popular formats: DBF etc |
|
|
|
| Other Data Manipulation Tools |
|
|
|
| Data transfer |
|
|
|
| Transferring data to SQL script as INSERT statement |
|
|
|
| Transferring data to a SQL file with designated SQL format and encoding |
|
|
|
| Data synchronization |
|
|
|
| Backup/Restore |
|
|
|
| Backing up/restoring database |
|
|
|
| Backing up database with chosen database objects |
|
|
|
| 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 |
|
|
|
| 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 |
|
|
|
| Notification email Support SSL/TLS |
|
|
|
| Server Security and Maintenance Services |
|
|
|
| Analyzing, re-indexing tables |
|
|
|
| Report Management Tools |
|
|
|
| Report Builder |
|
|
|
| Report Viewer |
|
|
|
| Other Useful Features |
|
|
|
| ER Diagram view |
|
|
|
| Ability to customize connection colorings |
|
|
|
| Support of database wide search |
|
|
|
| Objects search filter |
|
|
|
| Backing up database/table to SQL script |
|
|
|
| Executing SQL script |
|
|
|
| Duplicate/empty/truncate tables |
|
|
|
| Create table/view shortcut on desktop |
|
|
|
| Ability to create Favorites list |
|
|
|
| Ability to set auto-save for Query, etc |
|
|
|
| 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 |
|
|
|
Platforms
*ESS: Essentials Edition. |
Win
ESS
|
Mac
ESS
|
Linux
ESS
|
| Oracle Objects Management |
|
|
|
| Support Oracle Servers 8.1 or above (Mac OS X Edition starts from Oracle 8.1.7) |
|
|
|
| Create/drop schemas |
|
|
|
| Support all Oracle objects: tables (Normal, External and Index Organized), views, stored procedures/functions |
|
|
|
| Support all subobjects: fields, indexes, foreign keys, uniques, checks and triggers |
|
|
|
| Managing directories, tablespaces, public database links and public synonyms |
|
|
|
| Managing database links, indexes, 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 |
|
|
|
| Connection Management and Navigation |
|
|
|
| Multiple local/remote Oracle server connections |
|
|
|
| Support of Basic Connection |
|
|
|
| Support of TNS Connection |
|
|
|
| Connection to Oracle Server through SSH |
|
|
|
| Keep connection alive |
|
|
|
| Export/Import connections settings |
|
|
|
| Feature Rich Oracle PL/SQL Code Debugger |
|
|
|
| Support on showing interactive and real-time debugging information |
|
|
|
| Ability to set simple and complex breakpoints |
|
|
|
| Stepping through a function, i.e. Step Into, Step Over and Step Out |
|
|
|
| Inspecting variables and expressions |
|
|
|
| Stack traces |
|
|
|
| Data Viewer and Editor |
|
|
|
| Grid view |
|
|
|
| Form view |
|
|
|
| TEXT, Hex and BLOB/BFile viewer/editor |
|
|
|
| Copying and pasting selected records |
|
|
|
| Customize display formats |
|
|
|
| Incremental search, sorting and formatting table grid |
|
|
|
| Ability to show/hide table ROWID |
|
|
|
| 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 |
|
|
|
| Code completion for SQL editors |
|
|
|
| Code outline |
|
|
|
| SQL Code Beautifier/Minifier |
|
|
|
| Multiple SQL editors with syntax highlighted feature |
|
|
|
| Support code folding, highlighted matches words and brackets |
|
|
|
| Copy SQL with quote |
|
|
|
| Word Wrap |
|
|
|
| Zoom In/Out for SQL editors |
|
|
|
| Enhanced find and replace options in SQL editors |
|
|
|
| Ability to preview SQL before execution |
|
|
|
| Support to return multi-resultsets |
|
|
|
| SQL*Plus |
|
|
|
| Data Modeling Tools |
|
|
|
| Reverse engineering |
|
|
|
| Support of several diagram notations like Crow's Foot, IDEF1x and UML |
|
|
|
| Ability to create/edit/drop database objects, visually set relationships between them |
|
|
|
| Support of auto layout |
|
|
|
| Support numerous visual customization options like adding vertices, layers, images and notes/labels |
|
|
|
| Zoom In/Out for ER diagram |
|
|
|
| Comparing and synchronizing database/model |
|
|
|
| Generating complex SQL/DDL |
|
|
|
| Multi-page print preview |
|
|
|
| Ability to print the database diagram to PDF file |
|
|
|
| Ability to save the database diagram as a graphic file, i.e. PNG, SVG |
|
|
|
| Diversified Import and Export Competence |
|
|
|
| Importing data from ODBC: MSSQL etc |
|
|
|
| Importing data from MS Excel |
|
|
|
| Importing data from MS Access |
|
|
|
| Importing data from plain text file formats : TXT, CSV, XML etc |
|
|
|
| Importing data from other file formats : DBF etc |
|
|
|
| Exporting data to MS Excel |
|
|
|
| Exporting data to MS Access |
|
|
|
| Exporting data to HTML |
|
|
|
| Exporting data to plain text file formats : TXT, CSV, XML etc |
|
|
|
| Exporting data to most popular formats: DBF etc |
|
|
|
| Other Data Manipulation Tools |
|
|
|
| Data transfer |
|
|
|
| Transferring data to SQL script as INSERT statement |
|
|
|
| Transferring data to a SQL file with designated SQL format and encoding |
|
|
|
| Data synchronization |
|
|
|
| Structure synchronization |
|
|
|
| Schedule for Batch Job |
|
|
|
| Ability to set schedule on 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 |
|
|
|
| Notification email Support SSL/TLS |
|
|
|
| Server Security and Maintenance Services |
|
|
|
| Visual user management |
|
|
|
| Visual privilege manager |
|
|
|
| Ability to duplicate user, role |
|
|
|
| Maintaining tables like Table Lock, Row Movement, Shrink Space, Table Move, Validate Table Structure and Collect Table Statistics |
|
|
|
| Server Monitor to view and change system variables, to view server status information |
|
|
|
| Report Management Tools |
|
|
|
| Report Builder |
|
|
|
| Report Viewer |
|
|
|
| Other Useful Features |
|
|
|
| ER Diagram view |
|
|
|
| Ability to customize connection colorings |
|
|
|
| Support of database wide search |
|
|
|
| Objects search filter |
|
|
|
| Backing up schema/table to SQL script |
|
|
|
| Executing SQL script |
|
|
|
| Duplicate/empty/truncate tables |
|
|
|
| Create table/view shortcut on desktop |
|
|
|
| Ability to create Favorites list |
|
|
|
| Ability to set auto-save for Query, Function, etc |
|
|
|
| Print Schema 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 |
|
|
|
Platforms
*ESS: Essentials Edition. |
Win
ESS
|
Mac
ESS
|
Linux
ESS
|
| PostgreSQL Objects Management |
|
|
|
| Support PostgreSQL Servers 7.3 or above |
|
|
|
| Create /drop databases and schemas |
|
|
|
| Support all PostgreSQL objects: tables, views and functions |
|
|
|
| Support all subobjects: fields, indexes, 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 PostgreSQL server connections |
|
|
|
| Connection to PostgreSQL Server through SSH |
|
|
|
| Connection to PostgreSQL Server through HTTP |
|
|
|
| Support SSL secure connection for PostgreSQL 8.4 above |
|
|
|
| Keep connection alive |
|
|
|
| Export/Import connections settings |
|
|
|
| Customize selected databases to work with |
|
|
|
| Data Viewer and Editor |
|
|
|
| UUID/GUID Generator |
|
|
|
| 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 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 |
|
|
|
| Code completion for SQL editors |
|
|
|
| SQL Code Beautifier/Minifier |
|
|
|
| Multiple SQL editors with syntax highlighted feature |
|
|
|
| Support code folding, highlighted matches words and brackets |
|
|
|
| Copy SQL with quote |
|
|
|
| Word Wrap |
|
|
|
| Zoom In/Out for SQL editors |
|
|
|
| Enhanced find and replace options in SQL editors |
|
|
|
| Ability to preview SQL before execution |
|
|
|
| Support to return multi-resultsets |
|
|
|
| SQL console |
|
|
|
| Data Modeling Tools |
|
|
|
| Reverse engineering |
|
|
|
| Support of several diagram notations like Crow's Foot, IDEF1x and UML |
|
|
|
| Ability to create/edit/drop database objects, visually set relationships between them |
|
|
|
| Support of auto layout |
|
|
|
| Support numerous visual customization options like adding vertices, layers, images and notes/labels |
|
|
|
| Zoom In/Out for ER diagram |
|
|
|
| Comparing and synchronizing database/model |
|
|
|
| Generating complex SQL/DDL |
|
|
|
| Multi-page print preview |
|
|
|
| Ability to print the database diagram to PDF file |
|
|
|
| Ability to save the database diagram as a graphic file, i.e. PNG, SVG |
|
|
|
| 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 plain text file formats : TXT, CSV, XML etc |
|
|
|
| Importing data from other file formats : DBF etc |
|
|
|
| Exporting data to MS Excel |
|
|
|
| Exporting data to MS Access |
|
|
|
| Exporting data to HTML |
|
|
|
| Exporting data to plain text file formats : TXT, CSV, XML etc |
|
|
|
| Exporting data to most popular formats: DBF etc |
|
|
|
| Other Data Manipulation Tools |
|
|
|
| Data transfer |
|
|
|
| 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 |
|
|
|
| Backing up/restoring database |
|
|
|
| Backing up database with chosen database objects |
|
|
|
| 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 |
|
|
|
| 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 |
|
|
|
| Notification email Support SSL/TLS |
|
|
|
| Server Security and Maintenance Services |
|
|
|
| Visual user management |
|
|
|
| Visual privilege manager |
|
|
|
| Ability to duplicate user, role, etc |
|
|
|
| Analyzing, vacuuming and reindexing tables |
|
|
|
| Server Monitor to view system variables and server status information |
|
|
|
| Report Management Tools |
|
|
|
| Report Builder |
|
|
|
| Report Viewer |
|
|
|
| Other Useful Features |
|
|
|
| ER Diagram view |
|
|
|
| Ability to customize connection colorings |
|
|
|
| Support of database wide search |
|
|
|
| Objects search filter |
|
|
|
| Backing up schema/table to SQL script |
|
|
|
| Executing SQL script |
|
|
|
| Duplicate/empty/truncate tables |
|
|
|
| Create table/view shortcut on desktop |
|
|
|
| Ability to create Favorites list |
|
|
|
| Ability to set auto-save for Query, Function, etc |
|
|
|
| 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 |
|
|
|
|
|
|
|
|
|
| |
|
 |
카트 보기 [ 
