+1Hi,
I’m able to create an ERD (Physical Data Model – PDM) in Lucidchart by importing a CSV from an Azure SQL Server database.
My question is: can these imported objects also be used to generate an ERD at the conceptual (CDM) or logical (LDM) level? Reason: When I drag it is only creating the table as physical model.
Additionally, could you share guidance or a link on how Lucidchart handles ERDs when working with multiple databases?
Thanks, Sreedhar
Best answer by Micah
Hi
Regarding your second question about multiple databases - is the differentiation problem you’re describing with the diagram itself/actual tables on the canvas, or with the imported data in the shapes panel on the left of your editor?
+24Hi
Lucidchart’s SQL/CSV import is designed to create a physical ERD; it does not automatically Promote those tables into separate conceptual (CDM) or logical (LDM) models, so those layers need to be modeled manually using the same imported tables as a reference.
For multiple databases, Lucidchart lets you import each database schema and work with them together in one document or as separate ERDs, but there is no special multi‑DB abstraction layer.
To learn more:
ERD enhancements and newly supported databases! 🆕 | Community
Visualize databases with Entity Relationship Diagrams in Lucidchart | Community
Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards
+1Thanks for the reply. I’ve already created the physical models for each database.
If the process is entirely manual, it becomes a very long task since I’m working with 200+ tables across multiple databases. My expectation was that Lucidchart could at least generate a logical model from the physical import, which we could then refine and tune manually.
Also, when I import multiple database schemas, all the tables are grouped together, making it difficult to distinguish which table belongs to which database. I understand there is schema-level separation, but visually it’s still hard to manage at scale.
+24Hi
Thanks for adding more realistic challenges from the user perspective - will wait to hear from the Internal Lucid team to see we get any additional ideas on this
CC:
Best Regards
+20Hi
Regarding your second question about multiple databases - is the differentiation problem you’re describing with the diagram itself/actual tables on the canvas, or with the imported data in the shapes panel on the left of your editor?
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
