Search Databases

Database Searcher is like a search engine for your database. It will search all columns for all tables over multiple databases. It will return a summary of matches, the generated SQL and the detailed matches per table. It will also search the schema by the table names or column names. Knowledge of SQL queries is not required. Database Searcher supports Firebird, MS Access, MySQL, Oracle, PostgreSQL, SqLite, SQL Server, VistaDB Version 5 and VistaDB Version 6.

While it can be purchased separately, this product is also included in the Gold Suite. Gold Suite subscribers receive all product updates and all new products as part of a yearly subscription. It is the best value in the industry.

Use Cases

• How many orders were created or modified in the last hour? Enter the From Date and Time and the To Date and Time and specify %order% for the table name.
• The business needs to change from 5 digit zip code to zip+4. How many postal code columns in the database are only 5 digits long? Check schema search and then enter %postal%. Do a second search of %zip%
• You need to find all related information for CustomerID 12345. Enter 12345 for the search term and the Match Column Names of CustomerID.
• Customers reported problems during the Black Friday sale at 6am on the website. You want to search all logs for errors between 6am and 7am. Enter error for the search term, a from date of 11/25/2016 6:00 AM, a to date of 11/25/2016 7:00 AM. For the Match Table Names enter %log%
• As a developer you need to find a drop down value somewhere in the database for the word Fedex. You know there are less than 10 possible values in the drop down. Enter Fedex for the search term and specify 10 for the Max Table Rows and it will do an exact match on all string columns in the database that have 10 or less rows in the table.

Features

There are no other stand alone applications that are able to search databases without having knowledge of SQL.

Download a free 14 day trial today.

• Full working version
• Includes technical support
• Works with Firebird, MS Access, MySQL, Oracle, PostgreSQL, SqLite, SQL Server, VistaDB Version 5 and VistaDB Version 6.

Download Options

• Download Full Installer
• Download Zip No Installer
• Chocolatey: choco install database-searcher -y --version 2.11.0.0
• PortableApps.com Portable Version
• Online Help

System Requirements

• Works with any version of Windows with a minimum of Windows 7 SP1 or a minimum of Windows Server 2008 R2 SP1.
• .NET Framework 4.7.2 or higher.
• Firebird, MS Access, MySQL, Oracle, PostgreSQL, SqLite, SQL Server, Vista DB Version 5 or Vista DB Version 6

Step 1:  Click the plus button. 

Step 2:  Enter a friendly name of your database. 

Step 1:  Enter the server, database, user name, and password as given to you by your database administrator.

Step 2:  Click Connect

Step 3:  Enter the Search Term

Step 4:  Click Search

See the help file for an explanation of all the options.

Q: How do I use my license key?
A: Click "Enter Registration" in the help menu then restart the application.

Q: I lost my license key how do I retrieve it?
A: Go to your account

Q: I lost my software how do I retrieve it?
A: Go to downloads

Q: Where can I download the latest version of my software?
A: Click the download tab.