DDL Generation using Visio

[APentyala]

Dear All,

I’ve created a model in Microsoft Visio using the database model diagram, but I can’t find the option to generate and export the DDL for the tables. Could you please advise on how to export the DDL for all tables or for specific tables?

Visio Version - Microsoft® Visio® Plan 2 MSO (Version 2407 Build 16.0.17830.20210) 64-bit

Thanks in Advanced

[#2]

@APentyala 

Try this:

Export shape data to a database - Microsoft Support

[#3]

HI @Kidd_Ip 

Thank you for your response. I’ve tried both wizards, but they aren't displaying the original column names from the model instead, it shows the default column names.

I created the model using ER. Additionally, could you let me know if there’s a way to generate DDLs to a file/clipboard instead of directly in the database?