Skip to main content
hamburger menu
+ Create a topic
S
sreedharv
November 25, 2025
Solved

Creating Logical (LDM) and Conceptual (CDM) ERDs in Lucid after importing from Azure SQL

  • November 25, 2025
  • 4 replies
  • 98 views

Hi,

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 ​@sreedharv! Thanks for getting the conversation going ​@Humas1985 - you’re right, unfortunately automatic creation of CDM or LDM files isn’t currently supported. I certainly understand, though, how manually creating them using the physical model as a reference can become quite difficult with the size of your model and multiple databases. I’d love to understand what your ideal experience would be here! Would you prefer to build a CDM or LDM (post-import) in the same way as the physical model, where you add tables to your diagram by dragging and dropping? Or would you prefer that you create a physical model and then have the option to convert the entire model to a logical or conceptual level?

 

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?

 

Comments

Humas1985
Lucid Legend Level 10
Humas1985Lucid Legend Level 10
Lucid Legend Level 10
November 25, 2025

Hi ​@sreedharv 

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

Huma || Lucid Legend
S
sreedharvAuthor
November 25, 2025

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

    Humas1985
    Lucid Legend Level 10
    Humas1985Lucid Legend Level 10
    Lucid Legend Level 10
    November 26, 2025

    Hi ​@sreedharv 

    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: ​@Micah - If you can help to this context would be helpful.

    Best Regards

    Huma || Lucid Legend
    Micah
    MicahAnswer
    Lucid community team
    November 26, 2025

    Hi ​@sreedharv! Thanks for getting the conversation going ​@Humas1985 - you’re right, unfortunately automatic creation of CDM or LDM files isn’t currently supported. I certainly understand, though, how manually creating them using the physical model as a reference can become quite difficult with the size of your model and multiple databases. I’d love to understand what your ideal experience would be here! Would you prefer to build a CDM or LDM (post-import) in the same way as the physical model, where you add tables to your diagram by dragging and dropping? Or would you prefer that you create a physical model and then have the option to convert the entire model to a logical or conceptual level?

     

    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?

     

    Level up your skills & unlock exclusive perks!

    Join Lucid Legends
    Lucid Software Inc. Supplemental Community TermsAccessibility statement

    Get Started

    Products

    Solutions

    Company

    Resources

    Privacy Legal Cookie privacy choices Cookie policy Your privacy choices
    © 2026  Lucid Software Inc.