Table of Contents:

    Creating cross-database table relationships

    Applies to: 9.x (current), Article available also for: 8.x, 7.x, 6.x

    Dataedo 6.0 brought unique capability of defining relationships across databases. Both databases need to be imported to the same Dataedo repository.

    Once you have all required databases and tables in place and want to create new cross-database relationship go to foreign key table.

    In the Relations tab click Add relation button in the ribbon or in right click context menu.

    Add relation button

    New relation form will open. Choose primary key table database from PK Database dropdown list and the table you want to define relation to in PK Table list.

    New cross-db relation form

    Then define columns and save with OK.

    This way you can also create cross database ERDs. When you go to the ERD tab of a module, the available entities list contains objects from current documentation and objects related to objects currently on ERD from any documentation.

    Cross database ERD

    Found issue with this article? Comment below
    There are no comments. Click here to write the first comment.

    By continuing to use our website, you consent to the use of cookies in accordance with our Privacy Policy (updated 28-04-2020).