DBPowerTools is a collection of database utilities capable of performing database comparisons, creating sql scripts and searching for strings inside a database.

The tools included are DBDiff, DBScripter, DBSearch and DBSchemaExplorer.


 

DBDiff:
	DBDiff is an ODBC database utility that allows you to compare 2 databases. Any two databases accessible from your system can be compared. The comparison can be performed at three levels of depth in the databases, structural, indexes and/or data. The structural comparison compares the tables of both databases, column names and column types, the indexes compare indexes types and columns, and the data level compares the data stored on the tables of the databases. DBDiff creates a user-friendly report that includes the databases analysis, structural, indexes and data analysis.
DBScripter:
	DBScripter is an ODBC utility that creates a SQL script from any database accessible from your system. The script created can contain structure, indexes and/or data statements to fully or partially replicate a database. It is fully configurable to meet all different DBMS' requirements like special wording, formatting, and even special behavior of the SQL tool to be used to run the script. Configurations can be saved to allow for easy reuse of the customization. DBScripter comes with pre-configured profiles (customizations) for the most common databases.
DBSearch:
	DBSearch is an ODBC tool that lets you search for any string, substring, prefix or suffix within any database's tables, columns, data types, indexes, and/or data. The search can be customized to include/exclude some tables, or particular columns. Progress meters show you the progress at each step of the search. A report is produced to clearly show the results of the search, which can be viewed on line or saved to the disk.
DBSchemaExplorer:
	DBSchemaExplorer is an ODBC database utility that allows you to browse through the structures of multiple databases in a Windows Explorer-like fashion. Any database accessible from your machine through ODBC can be used, and there is no limitation on the number of databases you can explore simultaneously. It also comes with a search feature that can search for strings, sequences, columns, indexes, and more, in one specific database or across all selected databases. DBSchemaExplorer also has the capability of generating and printing reports that include the structural definition of the objects, their indexes, and primary and foreign keys.