- Details
- Created: 19 April 2013
|
Win
|
Win
|
Mac
|
Mac
|
Linux
|
Linux
|
|
| *Essentials Edition. | ||||||
|
|
||||||
| MySQL Servers 3.21 or above, Drizzle, OurDelta, Percona Server and MariaDB |
|
|
|
|
|
|
| Oracle Servers 8.1 or above ( Mac OS X Edition starts from Oracle 8.1.7 ) |
|
|
|
|
|
|
| PostgreSQL Servers 7.3 or above |
|
|
|
|
|
|
| SQLite 2 and 3 |
|
|
|
|
|
|
| SQL Server 2000 or above and SQL Azure |
|
|
|
|
||
| Multiple local/remote server connections |
|
|
|
|
|
|
| Oracle Basic connection |
|
|
|
|
|
|
| Oracle TNS connection |
|
|
|
|
||
| Connect a new or an existing SQLite database |
|
|
|
|
|
|
| Support encrypted SQLite file ( wxSQLite3 ) |
|
|
|
|
|
|
| Connect MySQL/Oracle/PostgreSQL/SQL Server through SSH |
|
|
|
|
|
|
| Connect MySQL/PostgreSQL/SQLite through HTTP |
|
|
|
|
|
|
| SSL secure connection for MySQL and PostgreSQL 8.4 above |
|
|
|
|
|
|
| Keep connection alive |
|
|
|
|
|
|
| Export/import connection settings |
|
|
|
|
|
|
| Show interactive and real-time debugging information |
|
|
|
|||
| Set simple and complex breakpoints |
|
|
|
|||
| Step through a function, i.e. Step Into, Step Over and Step Out |
|
|
|
|||
| Inspect variables and expressions |
|
|
|
|||
| Stack traces |
|
|
|
|||
|
|
||||||
| UUID/GUID generator for PostgreSQL/SQL Server |
|
|
|
|
|
|
| Grid view |
|
|
|
|
|
|
| Form view |
|
|
|
|||
| Text, Hex, BLOB and BFile viewer/editor |
|
|
|
|
|
|
| Code-highlight in Memo viewer |
|
|
|
|
||
| Web viewer for HTML codes data |
|
|
|
|
||
| Box selection and multi-cell editing |
|
|
|
|
||
| Copy and paste selected records |
|
|
|
|
|
|
| Copy selected records as INSERT/UPDATE statements |
|
|
|
|
||
| Customize display formats |
|
|
|
|
||
| Incremental search, sort and format table grid |
|
|
|
|
|
|
| Search columns |
|
|
|
|
|
|
| Find and replace |
|
|
|
|
|
|
| Show/Hide Oracle and SQLite tables ROWID |
|
|
|
|
|
|
| Raw mode editing: apply MySQL/PostgreSQL/SQLite/SQL Server built-in function |
|
|
|
|
|
|
| Foreign key data selection: locate the available values from the reference table |
|
|
|
|||
| Filter records |
|
|
|
|||
| Set number of records showing on each page |
|
|
|
|
|
|
|
|
||||||
| Visual SQL Builder |
|
|
|
|||
| Create parameter queries |
|
|
|
|
|
|
| Code completion |
|
|
|
|||
| Code outline |
|
|
|
|||
| SQL Code Beautifier/Minifier |
|
|
|
|||
| Multiple SQL editors with syntax highlighted feature |
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
| Preview SQL before execution |
|
|
|
|
|
|
| Return multi-resultsets |
|
|
|
|
|
|
| SQL console |
|
|
|
|
||
|
|
||||||
| Reverse engineering |
|
|
|
|||
| Build model with multiple schemas |
|
|
|
|||
| Several diagram notations like Crow's Foot, IDEF1x and UML |
|
|
|
|||
| Create/edit/drop database objects, visually set relationships between them |
|
|
|
|||
| Align and distribute database objects |
|
|
|
|||
| Search tables in diagram |
|
|
|
|||
| Auto layout |
|
|
|
|||
| Add vertices, layers, images and notes/labels |
|
|
|
|||
| Zoom in/out for ER diagram |
|
|
|
|||
| Compare and synchronize database/model |
|
|
|
|||
| Generate complex SQL/DDL |
|
|
|
|||
| Multi-page print preview |
|
|
||||
| Print database diagrams to PDF file |
|
|
|
|||
| Save database diagrams as a graphic file, i.e. PNG, SVG |
|
|
|
|||
|
|
||||||
| Import data from ODBC |
|
|
||||
| Import data from MS Excel |
|
|
||||
| Import data from MS Access |
|
|
||||
| Export data to MS Excel |
|
|
|
|||
| Export data to MS Access |
|
|
||||
| Export data to HTML |
|
|
||||
| Import/export data from/to plain text file formats: TXT, CSV, XML, JSON etc |
|
|
|
|
|
|
| Import/export data from/to most popular formats: DBF etc |
|
|
|
|||
|
|
||||||
| Data transfer ( Same or cross server type ) |
|
|
|
|||
| Transfer data to SQL script as INSERT statements |
|
|
|
|||
| Transfer data to a SQL file with designated SQL format and encoding |
|
|
|
|||
| Data synchronization |
|
|
|
|||
| Structure synchronization |
|
|
|
|||
| Oracle Data Pump |
|
|
|
|||
| SQL Server Backup/Restore |
|
|
||||
| Backup/restore MySQL/PostgreSQL/SQLite database |
|
|
|
|||
| Backup MySQL/PostgreSQL/SQLite database with chosen database objects |
|
|
|
|||
| Restore MySQL/PostgreSQL/SQLite database with chosen database objects |
|
|
||||
| Converte MySQL/PostgreSQL/SQLite backup file into SQL script |
|
|
|
|||
| Compress/decompress MySQL/PostgreSQL/SQLite backup files |
|
|
||||
| Set schedule on backup, query execution, import/export, data transfer and data synchronization |
|
|
|
|||
| Run profiles from different servers in a single schedule job |
|
|
|
|||
| Schedule report printing |
|
|||||
| Schedule to print report to files: PDF, Excel, HTML etc |
|
|||||
| Send notification e-mail for schedule task |
|
|
|
|||
| Attach Export Wizard/Report result files in Batch Job notification email |
|
|
|
|||
| Notification email supports SSL/TLS |
|
|
|
|||
| Visual user management |
|
|
|
|
|
|
| Visual privilege manager |
|
|
|
|
|
|
| Duplicate user, role, etc |
|
|
|
|
|
|
| Maintain database/schema objects |
|
|
|
|
|
|
| Server Monitor to view or change system variables and server status information |
|
|
|
|||
| Report Builder |
|
|||||
| Report Viewer |
|
|||||
| ER Diagram view |
|
|
|
|||
| Customize connection colorings |
|
|
|
|
|
|
| Database wide search |
|
|
|
|||
| Connection tree filter and objects search filter |
|
|
|
|
|
|
| Backup database/schema/table to SQL script |
|
|
|
|
|
|
| Execute SQL script |
|
|
|
|
|
|
| Duplicate/empty/truncate tables |
|
|
|
|
|
|
| Create table/view shortcut on desktop |
|
|
|
|
||
| Favorites list |
|
|
|
|||
| Auto-save for Query, Function, etc |
|
|
|
|
|
|
| Print database/schema/table structure |
|
|
|
|||
| Dock/tab windows |
|
|
|
|
|
|
| Virtual grouping:
provide logical organization over connections and objects |
|
|
|
|||
| Run profile from command line |
|
|
|
|||
| Log files: keep track on the actions have been performed in Navicat |
|
|
|
|
|
|
| Copy Connection Information into Clipboard |
|
|
|
|
|
|