Database Design

We have thre projects that are having databases designed for. All of these have a common set of tables (Human Resources, Facilities, States, etc). I would like to build each of these database seperately, but share these common tables among all three pro
jects.
While I know we can join tables between databases, I would like to work with these in the diagram designer. Is there anyway to accomplish this?
You can create views in each DB that reference the common tables in
another DB. I don't think there's any way to show tables from another
database in EM's diagram tool though. Best use a grown-up diagram app
such as MS Visio.
David Portas
SQL Server MVP

Database Design

We have thre projects that are having databases designed for. All of these
have a common set of tables (Human Resources, Facilities, States, etc). I w
ould like to build each of these database seperately, but share these common
tables among all three pro
jects.
While I know we can join tables between databases, I would like to work with
these in the diagram designer. Is there anyway to accomplish this?You can create views in each DB that reference the common tables in
another DB. I don't think there's any way to show tables from another
database in EM's diagram tool though. Best use a grown-up diagram app
such as MS Visio.
David Portas
SQL Server MVP
--

Database Design

We have thre projects that are having databases designed for. All of these have a common set of tables (Human Resources, Facilities, States, etc). I would like to build each of these database seperately, but share these common tables among all three projects.
While I know we can join tables between databases, I would like to work with these in the diagram designer. Is there anyway to accomplish this?You can create views in each DB that reference the common tables in
another DB. I don't think there's any way to show tables from another
database in EM's diagram tool though. Best use a grown-up diagram app
such as MS Visio.
--
David Portas
SQL Server MVP
--