ADO Explorer is a database tool that can help you with your daily work. It has features to organize connections and SQL commands, explore database objects, and use powerful scripter. It also supports MSSQL, ORACLE, and INFORMIX.
One of the key features of ADO Explorer is its ability to connect to any datasource accessible via ADO with OLE DB Provider or ODBC. With just a double-click, you can organize your connections in a tree and begin to explore the structure of your database. The tree provides a clear view of all elements of your database, including tables, columns, constraints, indexes, procedures, triggers, foreign keys, referencing keys, and more.
In addition, ADO Explorer comes equipped with a visual SQL query builder, as well as a powerful database scripter. You can even reverse engineer your database and transform data. And if you need to export data, ADO Explorer offers support for Excel, Word, HTML, XML, DBF, RTF, CSV, DIFF, SYLK, and LaTeX.
When constructing SQL queries, ADO Explorer makes it easy. All you have to do is select the tables you need, and it does the rest, generating all necessary joins automatically. The SQL command editor offers a variety of customization options, including a customizable color syntax parser, search and replace functions, bookmarks, and unlimited text length. And with SQL batching support, you can separate SQL commands with the "GO" command and run them in a sequence.
Other useful features of ADO Explorer include transaction support, editable recordset support, run-time parameters support, cross-server datatype conversion, BLOB view/edit support, printing support for SQL commands and results, db owner filtering, and a highly customizable environment.
Overall, ADO Explorer is a comprehensive and versatile solution for anyone working with databases. It provides a user-friendly interface and an array of features that can make work much easier and more efficient.
Version 2.00: N/A