CODEWITHSUNDEEP
sqloracle-databaseoracle-sql-data-modeler
Kadaj13
Kadaj13

Reputation: 1551

Importing relational diagram from Oracle data modeler to sql server

I have made a relational diagram in Oracle Data Modeler. Now I want to use it in microsoft sql server to write queries on it. How should I do?! I know I have to import it but I couldn't find how...

Upvotes: 0

Views: 320

Answers (1)

thatjeffsmith
thatjeffsmith

Reputation: 22457

Set the relational model properties to 'SQL Server' for site type - SQL 2008 is the highest we support at this time.

Now create a physical model, of type SQL Server.

Now export your model to SQL - use this button

Data Modeler DDL Generation Button

Set your options, and go.

We won't create a database for you. You'll need your own SQL Server already up and running, but then you can have your objects created.

Upvotes: 1

Related Questions