[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [Newsgroup Home]
[news.eclipse.dtp] Re: generate entities problem with sql server

What version of DTP are you using? The MSSQL support has improved in our 
Galileo (1.7) work that's due out in June 2009. That may solve the issue.
--Fitz

"ted beckett" <work.beckett@xxxxxxxxx> wrote in message 
news:9ddd69bc09a6796cf87835c317f97191$1@xxxxxxxxxxxxxxxxxx
> Hi, when I generate entities against a SQL Server 2005 database, entity 
> relationships are not being generated. Foreign key constraints are defined 
> for the database.
> I've shown a constraint definition below which I got from Microsoft SQL 
> Server Management Studio.  Any help is appreciated - Ted
>
> ALTER TABLE [dbo].[ALL_EQUIPMENT]  WITH NOCHECK ADD  CONSTRAINT 
> [FK_EQUIPMENT_SUM_AFFILIATION] FOREIGN KEY([AFFILIATION])
> REFERENCES [dbo].[L_AFFILIATION] ([AFFILIATION_CODE])
> NOT FOR REPLICATION
>