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.
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.