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 (table, column, constraint, indexe, procedure, trigger, foreign key, 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 function, bookmark, 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 )
Digg This!
Add to Del.icio.us
Add to Furl
Stumble
Recommend
Bookmark
Updates