Page 1 of 1
Diagram Inter-Database Virtual Relations
Posted: Tue 12 Mar 2019 16:33
by cforsto
The database diagram tool allows me to add tables from multiple databases onto the same diagram. However, I am unable to create a virtual relation between tables from different databases. Is there any way I can create/display this inter-database relation in the diagram?
Re: Diagram Inter-Database Virtual Relations
Posted: Wed 13 Mar 2019 09:08
by alexa
Could you please let us know what do you need this for?
The problem is that SQL Server itself doesn't allow cross-database FK.
Re: Diagram Inter-Database Virtual Relations
Posted: Thu 14 Mar 2019 18:25
by cforsto
True, but I'm not doing a FK. I'm wanting to add a virtual foreign key to show the implied relationships between tables in multiple databases. I have a transactional database that I need to show how some of those tables relate to a database that has more static data.
We don't use foreign keys in our databases because, right or wrong, we'd rather leave the control with the developer instead of the dbms.
Re: Diagram Inter-Database Virtual Relations
Posted: Fri 15 Mar 2019 09:54
by alexa
Thank you for the reply.
Could you please still tell us what do you need this for?
Re: Diagram Inter-Database Virtual Relations
Posted: Fri 15 Mar 2019 13:48
by cforsto
If you read my earlier reply, I tell you why I need it. I need to show the implied relationships that exist between the databases. For example: DatabaseA.dbo.TableA.TableAid = DatabaseB.dbo.TableB.TableAid
Re: Diagram Inter-Database Virtual Relations
Posted: Wed 20 Mar 2019 09:22
by alexa
Thank you for the reply.
There is no such a possibility. Though, you can add a suggestion on the UserVoice forum where other users can vote for it
https://devart.uservoice.com/forums/177 ... sql-server
We collect and analyze the information from this forum in order to make a proper roadmap for the next product versions.