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
Easy to use – Useful for support personnel, developers, business analysts, and testers
Fast - Database Searcher builds parameterized queries for each database type with no locking reads for high performance. Schemas are cached. Table row counts are tuned for each database type.
Search Text – Search text columns in all tables for the selected databases for the specified search term
Supports Wildcards – Use the % sign character to perform partial matches of text. Supports StartsWith% , %EndsWith, and %Contains%
Search Integers – Search all integer type columns in all tables for the selected databases. Also supports a range of integers.
Search Real Numbers – Search all decimal and currency type columns in all tables for the selected databases. Also supports a range of real numbers.
Search Date Ranges – Search for all dates within a date range in all tables for the selected databases.
Primary Key Search – Confine column searches to primary keys.
Search Schema – Search for names of tables or columns for all tables in the selected databases.
Advanced Options – Include or Exclude specific tables or columns
Export SQL – Export the generated SQL to the clipboard
Export to Excel – Export the summary of matches and detailed results to Excel
1 Year Free Upgrades Purchase today and all upgrades are free for the next year.
60 Day Money Back Guarantee At Kellerman Software, we want you to be totally satisfied with your purchase. Receive a refund within 60 days when ordering from KellermanSoftware.com. Source code versions are non-refundable due to their nature.
Lifetime Support Lifetime E-mail technical support is included.