I'm trying out the demo of the DDT and when I create a relationship between 2 tables and go to deploy to server I get the following error:

Creating relationship 'FK_relationship' failed.
Create failed for ForeignKey 'FK_relationship'.
An exception occurred while executing a Transact-SQL statement or batch.
Foreign key 'FK_relationship' references invalid table 'master table'.
Could not create constraint. See previous errors.

There are no previous errors.  I'm using SQL Server Express.  I've tried setting the relationship from both tables as parent child, child parent with the same results.

Any ideas?

Thanks,

Ozzie

Ozzie,

I will look at this some more.  I am having a hard time making this work in SQL Server (aside from the DDT).  There is a SQL Server rule that is being violated and I am going to have to take a closer look.  It will more than likely be Monday before I get back to you on this.

There was an error within the DBEngine assembly during the foreign key creation where certain schema names were not references properly during the foreign key creation.  We fixed it, and I will let you know when a new update is available containing the fix.

So if I don't have my tables in different schemas within the database, it should create the relationship?

Ozzie

Yes.  But future updates will not have this issue.

The update posted yesterday will allow you to create relationships between tables in different schemas now