FireDAC - database structure

-
FireDAC - database structure
Has any of you written code that analyses foreign keys to find structural dependencies between tables? Are there components out there which can do the job for me?

Comments

  1. Bruce McGeeJanuary 19, 2015 at 5:57 AM

    Which database? TMS Data Modeler has a feature to reverse engineer its supported database, and it`s a lot less expensive than ER Studio or ER/Win.

    http://www.tmssoftware.com/site/tmsdm.asp

    ReplyDelete
  2. Lars FosdalJanuary 19, 2015 at 6:06 AM

    Bruce McGee - SQL Server, but I want to do it in Delphi (a diagnostic data drilling tool). Select a row, click on foreign key column, and drill to the linked row in the linked table.

    ReplyDelete
  3. Klaus EdelmannJanuary 19, 2015 at 7:59 AM

    IN SQL Server all these dependencies are retrievable via system tables and views. So you have "just" to get the knowledge where to find it ...

    ReplyDelete
  4. Lars FosdalJanuary 19, 2015 at 8:00 AM

    Klaus Edelmann - True, but I was hoping to leech off the previous work of someone else :)

    ReplyDelete
  5. Lars FosdalJanuary 19, 2015 at 8:01 AM

    The structures are available in "standardized" form through FireDAC as well.  http://docwiki.embarcadero.com/RADStudio/XE7/en/Metadata_Structure_(FireDAC)

    ReplyDelete
  6. Dobrin PetkovJanuary 19, 2015 at 10:48 AM

    http://docwiki.embarcadero.com/RADStudio/XE7/en/Working_with_Metadata_(FireDAC)
    :)

    ReplyDelete
  7. Jean-Marc KienerJanuary 20, 2015 at 1:01 AM

    Devart TmsMetadata from SDAC does the Job.
    http://www.devart.com/sdac/

    ReplyDelete

Post a Comment