Convert ER Diagram to SQL Diagram

Discussions about database modeling product Cameo Data Modeler functionalities

Moderator: Moderators

Convert ER Diagram to SQL Diagram

Postby andrew.mcgimpsey » Wed Oct 04, 2017 10:53 am

We currently have an ER Diagram that we use to model our SQL Server database. We transform this ER Diagram into a SQL diagram and then generate a script.dll file to get the SQL script to generate the appropriate SQL tables.

Is there any way to convert this ER diagram into a SQL Diagram with the same folder structure? Currently the transformation puts all of the structure into one TransformationOutput folder.

Thanks in advance.
andrew.mcgimpsey
Forum Newbie
Forum Newbie
 
Posts: 3
Posts Rating:0
Joined: Wed Jul 26, 2017 6:39 am

Re: Convert ER Diagram to SQL Diagram

Postby ieva.n » Wed Oct 04, 2017 2:12 pm

Hello,

What version of product do you choose? What transformation method did you use (convert in place or convert to specific folder)? Was the folders structure you wanted to keep selected during conversion?

Sincerely,
No Magic, Inc. Customer Support
ieva.n
No Magic
No Magic
 
Posts: 249
Posts Rating:17
Joined: Thu Aug 02, 2012 5:02 am
Full name: Ieva

Re: Convert ER Diagram to SQL Diagram

Postby andrew.mcgimpsey » Thu Oct 05, 2017 2:13 am

Hi,

Currently using version 18.5. Transform from ER to SQL (Generic). Place transformation model in package TransformationOutput. I would like to keep the ER folder structure in the transformation so that I can start to use the Data model to build the database up rather than starting with the ER model.

Thanks.
andrew.mcgimpsey
Forum Newbie
Forum Newbie
 
Posts: 3
Posts Rating:0
Joined: Wed Jul 26, 2017 6:39 am

Re: Convert ER Diagram to SQL Diagram

Postby ieva.n » Fri Oct 06, 2017 9:25 am

Hello,

When performing transformation, in step 4 there is a setting "Change package hierarchy" By default it is set to "Flatten packages", meaning that only top level package is kept. You can choose "Leave intact".

The setting for flattening the packages is default because SQL does not have packages. While SQL has schemas, they cannot be nested, so only one level is necessary.

Best regards,
No Magic, Inc. Customer Support
ieva.n
No Magic
No Magic
 
Posts: 249
Posts Rating:17
Joined: Thu Aug 02, 2012 5:02 am
Full name: Ieva


Return to Cameo Data Modeler

Who is online

Users browsing this forum: No registered users and 1 guest