Database Diagram

[Yama]

Hi,

I have a database Accounting with several table.
I have another database called Configuration with several configuration
tables.

In Database diagram how do I link a foreign key from Accounting to a primary
key in Configuration?

Thanks,

Yama

 

[Al Edlund]

AFAIK the model is limited to a single database.
al

 

[Yama]

Al,
Single database is elementary. My question revolves towards communication
with 2 databases. The parent database has a table containing PK. The child
database has a table with a FK with parent database. How can I represent this
in my database diagram and more impoortantly how do I do this?

Thanks,

Yama

 

[Clint]

I think what he's telling you is that Visio can't do it "properly", so
you'll have to work something else out. For example, use a naming
convention to indicate which database a table is in, add a custom property
to it, or use the Namespace to indicate the database.

As far as how to "do it", that would depend on the database, as you'll be
doing it from the database system, not from within Visio, so it will depend
on what database engine you're using. MS SQL Server, Oracle, Access, etc.

A quick Google search for "foreign key multiple databases" in Google News
shows some promising links, but you're going to have a kludge, probably.
Seeing all the work arounds and options makes it pretty obvious why Visio
doesn't support it.

http://groups.google.ca/group/micro...ey+multiple+databases&rnum=3#438996d33f746c8e

http://groups.google.ca/group/comp....ey+multiple+databases&rnum=4#951fcddf1a1eaf07

http://groups.google.ca/group/maili...ey+multiple+databases&rnum=6#3cc61e689e4206d2

Clint