Tool to search entire database

Philippe

Hi,

Is there a tool to search a string in a complete database? Without opening each object separately?


Regards,


Philippe

StephenG

Hi

You can use "Navision Developers Toolkit" which can be found on the 3.70 tools disc

Notice: In order to run Navision Developer's Toolkit your License file must be updated with the following Navision granules:
99,003,640 - Navision Developer’s Toolkit - Source Analyzer
99,003,650 - Navision Developer’s Toolkit - Compare & Merge

Scott_Frappier

Wouldn't this work?:
1.) Export all objects as text
2.) Open the exported file as UltraEdit32
3.) Search for the string of your choice

Luc_VanDyck

I think Philippe wants to search in every field of a table for data.

Maybe you could use the new datatypes RecordRef and FieldRef to step through all records of all tables, and search for a particular string. But it will be very slow.

Philippe

This is what I want to do:

We have a huge DB (30 Gig), with a few thousand new objects. In those objects, we have data that refers to shared files.
The DB is a heritage from an other NSC, and we do not have any documentation on it.
The DB will be moved to an other location, so we need to review all links to external objects (like fileshares etc.).
In order to avoid "forgetting" a few links, I would like to search all data for strings like "/:" or "h:/" or ....

any ideas?

Luc_VanDyck

Write some dataports to export all tables to a text-file. Then you can do your searching on those text-files.

Search in the downloads on this site for a dataport generator. This routine creates a Navision object text-file, containing dataports for selected tables. That object file needs to be imported in the database and compiled, and your dataports are created.

PrebenRasmussen

Or you can scan all fields of all records of all tables with RecordRef and FieldRef functionality.

I did this already looking specifically for date fields.

Use this:

Foreach Table do
- Foreach Record (using recref) do
  - Foreach Field (using virtual Fields) do
    - check recref.fieldref.value for string

...and it works