Toad World® Forums

TDM 4.3.3.6 multiple schemas and unique names (SQL Server 2012)


#1

Hello,

in my model I have two schemas, core and star, where core represents normalized tables and star is used for business intelligence.

There are many tables with the same name which have also similar relationships. In SQL Server the names must be unique within one schema only, so it is allowed to have two foreign keys with the same name if they are in different schemas.

But TDM always shows an error about duplicate constraint names.

Is there a way to disable these error messages?
And can I have confidence that TDM will handle these relationships correctly?

Thanks and best regards,
Gerald


#2

Hi,

can you send us sample model to modeling@quest.com, please?
I am not sure what “similar relationships” represent and what you exactly mean by two foreign keys with the same name.

See attached screenshots.

Regards,

Vaclav
verif-ok.png


#3

Hi,

can you send us sample model to modeling@quest.com, please?
I am not sure what “similar relationships” represent and what you exactly mean by two foreign keys with the same name.

See attached screenshots.

Regards,

Vaclav
verif-ko.png


#4

Hi,

thank you for your reply. In my model it is like your first example. As this should work I have to check if two relationships with the same name have been created by accident.

Regards,
Gerald