Skip to Main Content
Forums

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

DDL option to run in Azure Synapse

Rajesh ManivannanAug 2 2022 — edited Aug 2 2022

Hello,
I have created ERD in Oracle SQL Developer Data Modeler tool. Can anyone please let me know which option we need to pick in the data modeler tool to generate DDL to run that script in Azure Synapse.
Since we are migrating data from SQL server to Azure Synapse, while creating ERD we tested DDL on SQL Server. However, developers requesting to provide the Dedicated SQL format DDL scripts. Please let me know if that option is available in Oracle SQL Developer Data Modeler tool.
DDL.JPG
Thanks
Rajesh

Comments

DM generates for MS SQL Server - if that doesn't work you can use scripting to generate your own DDL - "Tools>Design rules and transformations>Table DDL Transformations"

1 - 1

Post Details

Added on Aug 2 2022
#developer, #sqldeveloper
1 comment
285 views