How to create a Database Diagram in SQL Server involving 2 databases? [closed]

Question

Is it possible to create a Database Diagram involving two databases in the same SQL Server project? I have a table in one database that I want to create a foreign key to another table in another database.

I'm using MS SQLServer 2008 R2.

Desiccate

I assume you mean in SSMS, and I believe the answer is no. – Scutt

Since you can't create a foreign key that references another database, I'm not sure what your goal is here. – Unwieldy

You cannot in SSMS, yet. You would need a third party tool. I'm sorry I can't offer any suggestions tho. – Deckle

Answer 1

The only way to do it would be to create, in one database, empty surrogates for the tables in the other database, then create the diagram using the surrogates... You might want to put these surrogates in a schema that identifies them as surrogates for the actual tables in the other DB.

Maniple