DBSearch 3.1

DBSearch is a useful ODBC database utility which searches for strings inside a database.
Any database that supports ODBC access can be used, as long as it is accessible from the machine running DBSearch.
DBSearch uses a carefully planned and designed algorithm for performing the quickest, most accurate search inside a database; this algorithm allows for five different levels of searches to be performed on the database.

Object Names Search - This level will search all objects of the database. It will find the objects that match your search criteria and display them as part of the results. You can tell DBSearch to skip the objects that you are not interested in searching. Use the Advanced Object Options to use this feature.

Object Column Names Search - This level will search in the column names of all objects found in the database. All instances found will be displayed as part of the results. Again you can define which objects you wish to include in the search in the Advanced Object Options, as well as particular columns you would like to exclude from the search, use the Advanced Columns Options to set this option.

Data Types Search - This level will search in the data types names of all columns in the database. By using such features as Advanced Table options (ability to skip table(s)) and Advanced Column Options (ability to exclude columns) you can tailor your search as needed. The general Options feature allows you to define whether the search will check the DBMS data types as found on the database - or if they need to be translated to ODBC standard types before performing the search.

Indexes Search - This level will search in the indexes names and columns found in the database. The Advanced Table Options allows you to skip all the indexes in a particular table per user specification.

Data Search - This level will search the data stored in the database. The Advanced Table Options allows you to skip all the data in a particular table per user specification.

To further refine your search, DBSearch provides the following options:

Any substring - When selected, DBSearch will report when your string is found in any place on the particular record being checked.

Match whole word only - When selected, DBSearch will ONLY report those instances where your string was found as an entire word within the record being checked.

Prefix - When selected, DBSearch will only report those instances where your string was found as a prefix to any word in the record being checked.

Suffix - When selected, DBSearch will only report those instances where your string was found as a suffix to any word in the record being checked.

Match case - When checked, DBSearch will perform a case sensitive search on the database according to your criteria as defined for all of the above parameters.

In order to make it easy to understand the output of the search, DBSearch creates a report that includes all the instances found in the database according to your criteria, in a user friendly manner, as well as other useful information about the database and the search.