Database Browser |
SQL Editor |
Browse
database objects such as schemas, tables, columns, primary and
foreign keys, views, indexes, procedures, functions, and more.
|
Edit SQL
scripts. Run SQL queries. Auto column and auto table lookup.
Uses the powerful EditRocket code editor that supports over 20
programming languages including SQL, PL/SQL, TransactSQL, SQL
PL, HTML, Java, XML, and more.
|
Database Tools |
Database Query Tool |
Visual
tools to create, alter, describe, execute, and drop database
objects such as tables, views, indexes, stored procedures,
functions, triggers, and more.
|
Includes
multi-tabular display of queries with options for filtering,
sorting, searching, and much more.
|
Import Data |
Export Data |
Import
data from various formats such as delimited files, Excel
spreadsheets, and fixed-width files.
|
Export
data in various formats such as delimited files, XML, HTML,
Excel spreadsheets, and SQL insert statements.
|
SQL Query Builder |
Built-in Database |
Create
select, insert, update, and delete SQL statements. Create
multi-table joins.
|
Includes
a robust relational database (HSQLDB) that is up and running
with no manual configuration out of the box.
|
Edit Table Tool |
Data Compare |
Insert,
update, and delete table data in a spreadsheet like format. Find
and replace data, preview generated SQL, and more. |
Compare
table data across databases, or compare the results of queries.
|
|
Features
- A Database Navigator for browsing database objects.
- An SQL Editor for creating SQL queries.
- Visual tools for creating, editing, dropping, describing, altering,
and viewing tables, views, indexes, and sequences
- Visual Tools for creating, editing, dropping, and executing stored
procedures, functions, and triggers
- A robust programming editor that embeds the powerful EditRocket code
editor that supports 20 programming
languages - including SQL, PL/SQL, TransactSQL, SQL PL, HTML, XML, and
more.
- Export Tool - Export data in various formats
- Import Tool - Import data from delimited files, Excel files, or fixed
width files into tables
- Ships with a built-in relational database engine (HSQLDB) that is up
and running out of the box and requires
no end-- user administration
- A Generate DDL Tool for generating table, view, and index DDL.
- Table / SQL Query Compare tool for comparing tables or queries across
multiple connections
- Database Data Search tool for searching single or multiple database
table and view data.
- Database Object Search tool for searching for database objects.
- Backup tools such as the Database Backup Tool and Table Backup Tool
- Database conversion tools for many popular databases.
- Auto column and auto table lookup
- SQL Formatter
- SQL Query builder tool
- SQL Query Scheduler tool
- Command Line Interface
- PHP Bridges for connecting to MySQL, PostgreSQL, and SQL Server
databases remotely via PHP enabled web servers
- An ASP bridge for connecting to MS SQL Server databases remotely via
ASP enabled web servers
- SQL GUI Tools for generating SQL for various operations
- Edit, delete, and insert database data with the Database Editor
- Works with all major operating systems including Windows, Mac OS X,
Linux, Solaris, and any other Java enabled OS
- Tested with Apache Cassandra, Apache Derby / JavaDB, Daffodil DB, DB2,
DBASE, DynamoDB, Firebird, FrontBase,
H2, HSQLDB / HyperSQL, Informix, Ingres, Interbase, Mckoi, Microsoft
Access, Microsoft SQL Server, Mimer SQL,
MongoDB, MySQL, Netezza, OpenBase, Oracle, Pervasive, Pointbase,
PostgreSQL, Redshift, Salesforce, SimpleDB,
Solid, SQLite, Sybase Adaptive Server Enterprise, Sybase SQL Anywhere,
and Teradata |