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