How do I create relationships between objects on different pages?

K

ksturgeon

I have a SQL 2000 database that has a couple hundred tables in it. Since I
don't have the benefit of a plotter I've created several pages in Visio for
Enterprise Architects and reverse engineered logical groups of tables on each
page; this will give me the ability to print tables for the various "subject
areas" on standard 8.5x11 sheets.

My dilemma is that there the database has foreign key constraints between
tables that I've chosen to display on different pages of the Visio model.
Naturally, since the related tables are on different pages, the relationship
connectors are not visible anywhere in the model. In and of itself that
wouldn't pose a problem but the foreign key constraints are not included in
the DDL script generated from the model.

I confess that this is the first time I've attempted to use Visio as a data
modeler; clearly it's simple enough to add new relationships between two
tables that are visible on a given page in the Visio model. How can I create
a relationship between two tables that are shown on different pages of the
Visio model?

Thank you in advance for any insight that you can share.
 
D

David Parker

The Data model is separate to the drawn objects. You can add a second
instance of a table on another page, then create the relationship, and
finally delete the second instance ... if you want to.
Ensure that you have the modelling options set accordingly before deleting
the table so that it doesn't delete it from the model.
 
K

ksturgeon

Thank you David. I appreciate your help. I was initially under the impression
that I could only have one copy of each table visible within the pages of the
drawing.
 
D

David Parker

....as are many users....

ksturgeon said:
Thank you David. I appreciate your help. I was initially under the
impression
that I could only have one copy of each table visible within the pages of
the
drawing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top