5 Replies Latest reply on Aug 2, 2019 12:56 PM by anecker

DM 18.4: Export DDL File contains unwanted table constraints

anecker Feb 1, 2019 3:40 PM

When I export my model as a DDL file the "Table Level Constraints" of not selected tables (DDL Generation Options > Tables) are written to the file.

RDBMS Type is SQL Server 2012.

Is this a known bug?

Regards

Andreas

1. Re: DM 18.4: Export DDL File contains unwanted table constraints

anecker Apr 17, 2019 7:16 AM (in response to anecker)

Still the same in 19.1. The "Generate in DDL" checkbox for table level constraints works only for Oracle ddl exports, for all other databases it is not working. :-(
Like Show 0 Likes(0)

Actions
2. Re: DM 18.4: Export DDL File contains unwanted table constraints

Philip Stoyanov-Oracle Apr 18, 2019 8:10 AM (in response to anecker)

Hi Andreas,
Is this a known bug?
At least not for me. But it works as expected in DM 19.1

Philip
Like Show 0 Likes(0)

Actions
3. Re: DM 18.4: Export DDL File contains unwanted table constraints

anecker May 10, 2019 8:53 AM (in response to Philip Stoyanov-Oracle)

Hi,
sorry I'm a little late...
This is what I'm doing in a new relational model for SQL Server:
- create two tables T1, T2
- create a table level constraint on T1
- Export DDL File and only check T2 on the tables tab

The generated script always contains the ALTER TABLE T1 ADD CONSTRAINT... for the table level constraint.
Andreas
Like Show 0 Likes(0)

Actions
4. Re: DM 18.4: Export DDL File contains unwanted table constraints

Philip Stoyanov-Oracle May 21, 2019 10:06 AM (in response to anecker)

got it, logged a bug

Philip
Like Show 0 Likes(0)

Actions
5. Re: DM 18.4: Export DDL File contains unwanted table constraints

anecker Aug 2, 2019 12:56 PM (in response to Philip Stoyanov-Oracle)

Bug is fixed in 19.2
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.