dbAnalyst
By Seabird Software, LLC
dbAnalyst is a powerful and versatile tool for database administrators and developers. With this single tool, you can manage several databases. That means you save money and time because you don?t have to acquire and learn multiple tools for different databases. With its competitive price, dbAnalyst is affordable for any size of company or even individual developers. dbAnalyst is a comprehensive cross-platform solution, handling end to end tasks such as identification of database properties, analysis, and exporting to multiple databases. It allows for translation and analysis among databases and even different versions of databases. dbAnalyst is highly intuitive, easy to learn and simple to use. Its powerful SQL console is always on the desktop, ready for analyzing any database. With its built-in intelligence, dbAnalyst guides the user via a series of scripts, database version by database version and feature by feature. Query wizards streamline database analysis and provide flexibility for executing analysis tasks. When a situation requires the database administrator?s immediate attention, automatic database alerts are sent. dbAnalyst: the one tool for all your database analysis needs. Unique features and functions of dbAnalyst: . SQL console always on the desktop . Intelligent, cross-database tool quickly connects to target database . Guides user on what to do and how to do it . Proactively imports database properties for the user . Full schema translation and export . Supports analysis of databases to feature level . Intuitive, simple user interface . Database alerts . Multiple databases/versions supported: OracleTM (8/8i/9i), Microsoft SQL ServerTM (7/2000), PostgreSQL (7.1/7.2, 7.3/7.4), iAnywhereTM (8.0), Microsoft AccessTM, dBase, MySQLTM (4.0), CacheTM (5.0), Text Folder, IBM DB2 (8.0)
Database Tour Pro
By Vitaliy Levchenko
Cross-database tool with report builder. Tested on Paradox, dBase, FoxPro, ASCII, Lotus, HTML, InterBase, Oracle, SQL Server, MS Access, MS Excel, PostgreSQL, MySQL. Main features are: -Viewing, editing, and printing data. -Automatically created reports and convenient report builder (with templates, expressions, preview, etc.). -Building queries with tools for convenient writing the SQL statesments. -Enhanced db grids, which allow to view and manipulate the data in the most convenient way. -Creating, deleting, modifying BDE aliases. -Command line support for most important operations like exporting, query executing etc. Log of performed operations. -Searching and replacing text. -Importing data to table from another table or a query. -Exporting data from any open table or query to another database or file (with format conversion). -Copying data to clipboard. -Calculating numeric fields (sum, avg, min, max, count). -Editing BLOB fields (MEMO, graphic). -Tools for editing string fields (trimming, changing case of symbols). -Sorting (logical and physical) data. -Filtering data. -Viewing structure with ability to print it. -Limited table restructure. -Reindexing tables. -Customized data view (color, font style, temporarily hiding any column). -Transaction control.
Database Tour
By Vitaliy Levchenko
Cross-database tool. Tested on Paradox, dBase, FoxPro, ASCII, Lotus, HTML, InterBase, Oracle, SQL Server, MS Access, MS Excel, PostgreSQL, MySQL. Main features are: -Viewing, editing, and printing data. -Building queries with tools for convenient writing the SQL statesments. -Enhanced db grids, which allow to view and manipulate the data in the most convenient way. -Creating, deleting, modifying BDE aliases. -Several command line options. -Searching and replacing text. -Importing data to table from another table or a query. -Exporting data from any open table or query to another database or file (with format conversion). -Copying data to clipboard. -Calculating numeric fields (sum, avg, min, max, count). -Editing BLOB fields (MEMO, graphic). -Tools for editing string fields (trimming, changing case of symbols). -Sorting (logical and physical) data. -Filtering data. -Viewing structure with ability to print it. -Reindexing tables. -Customized data view (color, font style, temporarily hiding any column). -Transaction control.
Exportizer
By Vitaliy Levchenko
Database utility for viewing, editing, filtering, copying, exporting database files (DB, DBF, TXT, CSV, etc.) to clipboard or file (XLS, RTF, XML, HTML, TXT, CSV, DBF) with full command line support. Many options allow full control over output. Includes several useful functions for data manipulating and bookmarking.
Multi-DB Querier
By Vitaliy Levchenko
Database SQL tool, which allows running the same SQL queries on multiple databases with similar structure at once. Can be used also for a single database as query and export tool. If running query returns resulting table, it can be exported to file of specified format. The tables from different databases can be either consolidated in one file or the result for each database can be exported to separate file. Possible output formats: Text (TXT), comma-separated values (CSV), dBase (DBF), XML, HTML, RTF, Microsoft Excel (XLS). The program can work with databases via BDE or ADO. It was tested on databases of the following types: Oracle (via BDE and ADO), Interbase (via BDE), Paradox (via BDE), Microsoft Access (via ADO) and dBase (via BDE and ADO). Theoretically, it can work also with other database types, supported by these two database engines. Connection parameters for each database are stored in the file of internal format, so if they are specified once, then there is no need to provide them again. The names of the most recently used SQL files are also stored. The program can run multi-statement scripts. Each statement must be separated by SQL terminating character or string, which is specified by the user. SQL queries are edited in convenient SQL editor with syntax highlighting. The most important operations can be performed also via command line.
Reportizer
By Vitaliy Levchenko
Database reporting tool. Easy creating, modifying and printing database reports. Allows to manage report collections. Works via BDE or ADO (ODBC) with many database types like DB, DBF, TXT, MS Access, etc. Tested on DB, DBF, TXT, CSV, Excel, HTML, Access, Oracle, Interbase, SQL Server. Supports expressions, grouping, calculating fields, multi-column reports, summary etc. Reports can be edited in visual report builder or in text mode. There is an ability to load and print reports from command line with set of options. Reports are band oriented. Reports can be printed or exported to file (HTML, XLS, TXT).