Post reply

Create a schema diagram from different databases

  • August 29, 2007 at 8:32 am

    #118328

    Buddies,

       I created a database schema diagram in database A using EM’s graphic user interfaces. Because there is a table, called table Y, in another database, called database B, also involves in the schema diagram, I need to add that table to the diagram, too. If I use EM’s graphic user interfaces, when I open the table list dialog while I am standing on database A, I cannot see table Y from database B. Please give me any idea to add table Y ito the diagram.

    Thank you in advance.

    johnsql

  • August 29, 2007 at 11:52 am

    #730216

    it's tough, because the relationships in a schema diagram are based on foreign keys...since you can't have a foreign key that references outside of the database you are looking at, all you can hope to do is create a copy the table in the current database and add a reference to that, but that's just a work around.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • August 29, 2007 at 11:54 am

    #730217

    The EM diagrammer is no designed to show those relationships. You need to use a tool live Visio or other than can work with multiple databases at a time.

  • August 29, 2007 at 2:40 pm

    #730257

    I am using EM's diagram GUIs to add tables to my db schema diagram, and when I add an extra table the the diagram, I will see a table list dialog and a dropdown lsit where I can pick a table and click OK. My problem, for other tables in a diffrent database, I cannot see from the dropdown list on the dialog.

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply