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
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.