Tool to search entire database

Philippe
Philippe Member Posts: 27
edited 2003-10-08 in Navision Attain
Hi,

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


Regards,


Philippe
www.vangele.be

Comments

  • StephenG
    StephenG Member Posts: 99
    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
    :(
    Answer the question and wait for the answer.
  • Scott_Frappier
    Scott_Frappier Member Posts: 90
    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
    Scott Frappier
    Vice President, Deployment Operations

    Symbiant Technologies, Inc.
    http://www.symbiantsolutions.com
  • Luc_VanDyck
    Luc_VanDyck Member, Moderator, Administrator Posts: 3,633
    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.
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • Philippe
    Philippe Member Posts: 27
    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?
    www.vangele.be
  • Luc_VanDyck
    Luc_VanDyck Member, Moderator, Administrator Posts: 3,633
    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.
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • PrebenRasmussen
    PrebenRasmussen Member Posts: 137
    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

Categories