I’m using 22.214.171.124 and generating a SQL Server 2008 database. When I create a foreign key relationship, the field placed in the child table is retaining the Identity attribute of the parent. Since only one field in a table can have the identity attribute turned on, this is an error and scripts generated from these definitions will fail.
Is there a setting to turn that off or is this a bug? I’m evaluating the product and, if this is a bug, it will constitute a show stopper for me. I don’t have the time to individually edit dozens of fields to turn off the identity attribute.
It’s such a fundamental thing that I can’t believe that it exists, that’s why I think it must be a setting somewhere.