|
|
ADO Explorer
-
Version
2.00
ADO Explorer is a powerful database tool using ADO
(ActiveX Database Objects) that allows you to proceed
quickly and efficiently in your everyday database work.
Now comes with ready to use native SQL commands for
MSSQL, ORACLE and INFORMIX servers!
Features:
- connect to any datasource accesible via ADO using
OLE DB Provider or ODBC
- organize your connections in a tree and connect with
a simple double-click
- explore database structure in a tree (tables,
columns, constraints, indexes, procedures, triggers,
foreign keys, referencing keys etc.)
- visual SQL query builder
- powerful database scripter (reverse engineer your
database, transform data)
- native support for MSSQL, ORACLE and INFORMIX
servers
- native support for any other SQL server is possible
(you can define your own SQL commands for your
datasource and explore database structure via these
commands rather than using ADO schemas)
- export data results to Excel, Word, HTML, XML, DBF,
RTF, CSV, DIFF, SYLK, LaTeX
- easy SQL construction (just select the tables and it
generates all necessary joins)
- full featured SQL command editor (customizable color
syntax parser, search/replace functions, bookmarks,
unlimited text length) (see picture)
- SQL batching support ("GO" command separates SQL
commands and runs them in a sequence)
- transactions support (you can run SQL commands in
transactions)
- editable recordsets support (you can run SQL command
in a way that produces editable recordset)
- run-time parameters support
- store your SQL commands in archive tree (either main
archive or connection-specific one )
- SQL commands history
- run scripts of unlimited length
- cross-server datatypes conversion
- BLOB view/edit support
- printing support for SQL commands and results
- db owner filtering
- highly customizable environment
|