- Details
- Created: 19 April 2013
|
Win
|
Win
|
Win
|
Mac
|
Mac
|
Mac
|
Linux
|
Linux
|
Linux
|
|
|
^Enterprise Edition. #Standard Edition. *Essentials Edition. |
|||||||||
|
|
|||||||||
| SQLite 2 and 3 |
|
|
|
|
|
|
|
|
|
| Multiple local/remote database connections |
|
|
|
|
|
|
|
|
|
| Connect a new or an existing database |
|
|
|
|
|
|
|
|
|
| Support encrypted SQLite file (wxSQLite3) |
|
|
|
|
|
|
|
|
|
| Connect database through HTTP |
|
|
|
|
|
|
|
|
|
| Export/import connection settings |
|
|
|
|
|
|
|
|
|
|
|
|||||||||
| Grid view |
|
|
|
|
|
|
|
|
|
| Form view |
|
|
|
|
|
|
|||
| Text, Hex and BLOB 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 |
|
|
|
|
|
|
|
|
|
| Raw mode editing: apply SQLite built-in function |
|
|
|
|
|
|
|
|
|
| Show/hide table ROWID |
|
|
|
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
|||
| 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 |
|
|
|
|
|
|
|||
| Transfer data to SQL script as INSERT statements |
|
|
|
|
|
|
|||
| Transfer data to a SQL file with designated SQL format and encoding |
|
|
|
|
|
|
|||
| Data synchronization |
|
|
|
|
|
|
|||
| Backup/restore database |
|
|
|
|
|
|
|||
| Backup database with chosen database objects |
|
|
|
|
|
|
|||
| Restore database with chosen database objects |
|
|
|
|
|||||
| Convert backup file into SQL script |
|
|
|
|
|
|
|||
| Compress/decompress backup files |
|
|
|
|
|||||
| 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 |
|
||||||||
| Send notification e-mail for schedule task |
|
|
|
|
|
|
|||
| Attach Export Wizard/Report result files in Batch Job notification email |
|
|
|
|
|
|
|||
| Notification email supports SSL/TLS |
|
|
|
|
|
|
|||
| Maintain database objects |
|
|
|
|
|
|
|
|
|
| Report Builder |
|
||||||||
| Report Viewer |
|
||||||||
| ER Diagram view |
|
|
|
|
|
|
|||
| Customize connection colorings |
|
|
|
|
|
|
|
|
|
| Database wide search |
|
|
|
|
|
|
|||
| Connection tree filter and objects search filter |
|
|
|
|
|
|
|
|
|
| Backup database/table to SQL script |
|
|
|
|
|
|
|
|
|
| Execute SQL script |
|
|
|
|
|
|
|
|
|
| Duplicate/empty/truncate tables |
|
|
|
|
|
|
|
|
|
| Create table/view shortcut on desktop |
|
|
|
|
|
|
|||
| Favorites list |
|
|
|
|
|
|
|||
| Auto-save for Query, etc |
|
|
|
|
|
|
|
|
|
| Print database/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 |
|
|
|
|
|
|
|
|
|