Skip to main content

Hi there. I have a SQL Server instance with two databases: RAW and STG.

  • There is a bunch of raw data in the RAW database
  • There are a bunch of tables on the STG database 
  • There are a bunch of stored procedures on the STG database that pull data from RAW process it and dump it onto STG.

Through these procedures the RAW and STG databases are linked. I was hoping Lucidchart’s ERD import tool would import these relationships but that does not appear possible. Am I missing something?

Hi Chris

Thanks for posting in the Lucidchart community! You can import each database as an ERD and should be able to import each into one document. To do so you'll need to import the databases separately into one document. Refer to our Create an Entity Relationship diagram article for details. Unfortunately the active dynamic link between these two databases will not carry over into the diagram. Hope this helps! Let me know if you have any questions. 


Reply