Book a Demo

Author Topic: Issue with importing from Sql Server 2008  (Read 3168 times)

Tani

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Issue with importing from Sql Server 2008
« on: May 07, 2013, 10:34:06 am »
Hi,
I am having issues when importing tables to EA and then generating DDL afterwards.

In Sql server 2008, the 'Insert on Update and Delete' for foreign keys are set to 'No action'. However after i import to EA and then generate DDL, the constraints become 'Restrict'. Below shows an example of a generated code. I expect it to have 'No action' referential integrity and not covert it to 'Restrict' as Restrict is not valid in SQL server 2008.

ALTER TABLE [dbo].[tblAdmission] ADD CONSTRAINT [FK_tblAdmission_tlkpAdmissionStatus_AdmissionStatus]
      FOREIGN KEY ([AdmissionStatus]) REFERENCES [dbo].[tlkpAdmissionStatus] ([AdStatId])
      [highlight]ON DELETE RESTRICT ON UPDATE RESTRICT[/highlight]


Please help! :(
Thanks