Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
johnsql
Posting Yak Master
161 Posts |
 Posted - 2007-08-29 : 10:25:05
|
| 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 |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-08-29 : 11:55:44
|
| Not possible, I'm afraid. You could add the table to database A and populate via a trigger or scheduled process. |
 |
|
|
johnsql
Posting Yak Master
161 Posts |
Posted - 2007-08-29 : 16:23:29
|
quote:
Originally posted by mwjdavidson
Not possible, I'm afraid. You could add the table to database A and populate via a trigger or scheduled process.
mwjdavidson,Can you please give me an example SQL script for how to do that?Thanks. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-30 : 01:13:30
|
| You may need third party data modeling tools. |
|
|
|
johnsql
Posting Yak Master
161 Posts |
Posted - 2007-08-30 : 12:17:22
|
quote:
Originally posted by rmiao
You may need third party data modeling tools.
rmiao, So can you give me some third party data modeling tools i can look for to buy so all tables can show all their column names and types automatically instead typing those?Thanks.johnsql |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-30 : 22:00:29
|
| ERWin or visio for instance. |
|
|
|
|
|
|
|
|
Create a schema diagram from different databases