 |
| ||||
Navicat Essentials for SQLite is a professional application designed to manage SQLite databases. It provides basic and necessary features you will need to perform simple administration on a database. It is a fast, reliable and affordable.
It supports the latest features including Trigger, Function, View, and it also comes with an Import/Export tool which allow user to import and export data from plain text file formats including TXT, CSV and XML.
Navicat Essentials for SQLite is a powerful database administration and development tool for SQLite. It works with SQLite version 2 and 3, and supports most of the latest SQLite features. It also lets you import/export txt and xml files to/from your SQLite databases through a well-designed wizard.
Here are some key features of "Navicat Essentials for SQLite":
SQLite Objects Management:< /b>
· 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 builtin 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 multiresultsets
· 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
· Multipage 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 da ta synchronization
· Schedule report printing
· Schedule to print report to files: PDF, Excel, HTML etc
· Sending notification email 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, reindexing 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 autosave 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
Requirements:
· Pentium II processor or above
· 65 MB of available hard-disk space
· SQLite
Limitations:
· 30 days trial
· Nag screen
Via: Navicat Essentials for SQLite 10.1.7
