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
Keywords: SQL query ADO database tool connection MSSQL server ORACLE INFORMIX SYBASE ODBC connect archive organizer tables columns procedures indexes constraints triggers parser MSACCESS Paradox DBase |
