search

dbeaver / dbeaver

Free universal database tool and SQL client
https://dbeaver.io
Apache License 2.0
38.94k stars 3.37k forks source link

Tables from different schemas are not linked #12819

Closed healiseu closed 3 years ago

healiseu commented 3 years ago

System information:

Connection specification:

Describe the problem you're observing:

I am creating a new ER diagram and then I drug and drop tables from different schemas in Microsoft Adventure Works 2019 database. In version 21.1.0 tables from different schemas are not shown linked in the diagram, i.e. the dotted or solid line that connects FK with PK is missing. I did not experience this problem with DBeaver ver. 21.0.0 so I had to uninstall the latest version and install this earlier one.

Please let us know if that is a bug or if it is some option which is not enabled.

BTW: IMHO DBeaver is one of the best database GUI managers out there and its ERD functionality is pretty good, kudos to all contributors and to Serge Rider for providing an excellent free community edition. Generally speaking I consider visualizing easily and correctly Table relationships on ERD super important for software engineers and developers. Perhaps for that reason that issue deserves some high priority in your busy schedule :-)

ShadelessFox commented 3 years ago

Hello @healiseu,

Thanks for the report. I believe this issue was fixed in #12765.

Can you try upgrading to the EA version?

healiseu commented 3 years ago

Hi @ShadelessFox, thank you for your prompt reply, it seems the issue I am reporting here is partially fixed. There are other than #12765 linking cases to cover e.g. PK--PK. To illustrate this, I am embedding two ERD schema images of MSQL Adventure Works 2019 created with:

DBeaver 21.0.0

AdventureWorks2019_dbeaver_21 0 0

DBeaver 21.1.0.EA

AdventureWorks2019_dbeaver_21 1 0 ea

Hope this will help you to solve sufficiently the problem

PS: Attached images have been created by me and I give full rights for anyone to publish and use them for whatever purpose. They demonstrate how powerful and easy it is to build complex ERD schemas with DBeaver.

ShadelessFox commented 3 years ago

Looks like our EA version is slightly outdated and does not feature the fix mentioned earlier, sorry.

I will let you know when it's updated.

ShadelessFox commented 3 years ago

Can you try again, please? Thanks.

https://dbeaver.io/files/ea/

healiseu commented 3 years ago

Hi, I confirm that your fix in the DBeaver EA from the repository of your link in the previous comment works fine. It produces exactly the first diagram above. Thank you

healiseu commented 3 years ago

I confirm that the problem of linking tables from different schemas is fixed in the new release of DBeaver Version 21.1.1.202106210824 Release date: June 21, 2021