| 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 |
|
|
|
|
|
|
|
|
|
View Cart [ 
