Solved

Are there any SQL query tools that can search through an ODBC database to find a specific record. Not SQL SERVER

Posted on 2013-10-28
5
396 Views
Last Modified: 2013-11-12
Just to preface that. I used used to use a tool until the owner stopped selling it. Called SQL Grep. What it would do was connect to any ODBC database and allow you to put in a record value such as a code or number. The tool called SQL Grep made by Gatherbird would search through the entire set of table and tell you the table and field where the record or records could be found. It was a simple little tool I could kick off and leave. Let it spend 15 minutes or so searching through the DB while I continued on working. The value was immesurable. It allowed me to reverse engineer a database and its tables so if I was looking for an invoice I could track it back and all its contents to know the probability of the where abouts of all the records. It saved me from having to query and guess at tables when tables can be a forest and finding the tree a challenge. An example:

I pick the ODBC Database.
I put in ....... number 10001
It tells me that number is found in 2 tables Invoice Header and Invoice Detail tables
Then it tells me the field in the table so Invoice. Invoice_Nbr
I can even search on table names that start with Cust or INV. etc. It was just a great tool that I could use with customers so that i can get results from within the data without having to spend tons of time searching the database and building Query after Query in SQL.

Does anyone know if there are other good tools out there that might be suited for that. Please advise if you have heard of anything. Thank you.
0
Comment
Question by:ruavol2
  • 2
  • 2
5 Comments
 
LVL 16

Accepted Solution

by:
DcpKing earned 250 total points
ID: 39608528
You could try out "SQL Search" from Red Gate. I believe that they have a "try before buy" scheme.

hth

Mike
0
 
LVL 51

Assisted Solution

by:Mark Wills
Mark Wills earned 250 total points
ID: 39610554
SQL workbench (not the MySQL one - this is a free third party / independent version) has a "grep" function to search all columns within a table or all tables...

http://www.sql-workbench.net/ is their home page, Manual has a link on the left part way down.

See 18.3 in the manual for a command line version, or 20.10 for the UI version. But think the UI is restricted to just text columns.

failing that, it could be possible to use an openquery  from SQL Server (and saw your comment) and search columns using dynamic SQL.

there are a couple of other tools, but seem to be DB specific.

Will be interesting to see what else is out there...
0
 
LVL 16

Expert Comment

by:DcpKing
ID: 39610579
ruavol2: In your header you have noted "Not SQL Server". Why then have you posted your question in two of the SQL Server fora? You might want to try some other fora here.
0
 
LVL 51

Expert Comment

by:Mark Wills
ID: 39610580
Ummm... Wonder if Gatherbird would release the source code considering they aren't continuing with it - they have an email address there.
0
 

Author Closing Comment

by:ruavol2
ID: 39643124
DCP_King The reason I said that is because I have asked the question before and deleted it because the argument was I had a tool that can search.  Yeah it searches but you have to knwo the table and field. I need to know that too....I figured who better to know tools on SQL search tools than SQL developers.....Honestly I did not have a clue where to put it.

Mark_Willis.....Yes sir you have the right idea. It is a great tool for $45 dollars. Now I cannot sell it to my customers who love it. Nor can I get them to respond to me. They have responded often but something has changed. I have begged them to let me keep the software up and give them a portion of the proceeds for each sale. No response even though they said they woudl get back with me. Any who.....good idea.
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now