Code first oracle script migrations with many commands

Code first oracle script migrations with many commands

Postby twistyWater » Wed 29 Nov 2017 16:43

When I generate an initial script with multiple tables creation, there is no delimiter for each oracle commands :

Code: Select all
CREATE TABLE MY."__EFMigrationsHistory" (
  "MigrationId" NVARCHAR2(150) NOT NULL,
  "ProductVersion" NVARCHAR2(32) NOT NULL,
  PRIMARY KEY ("MigrationId")
)
CREATE TABLE MY.TABLE1 (
  ID RAW(16) NOT NULL,
  PRIMARY KEY (ID)
)
CREATE TABLE MY.TABLE2 (
  ID RAW(16) NOT NULL,
  TABLE1ID RAW(16) NULL,
  PRIMARY KEY (ID)
)
CREATE INDEX IX_TABLE2_TABLE1ID ON MY.TABLE2 (TABLE1ID)


This script doesn't run in SQL command tool. We need to add semi-colon at the end of each instructions. Is there a way to configure that kind of behavior?

We are using dotConnect for Oracle 9.5.399

Thank you
twistyWater
 
Posts: 2
Joined: Wed 29 Nov 2017 15:39

Re: Code first oracle script migrations with many commands

Postby Shalex » Mon 04 Dec 2017 18:00

Could you please send us a small test project for reproducing the issue? Also specify the versions of your Oracle Server, Oracle Client, EF version used.
Shalex
Devart Team
 
Posts: 7839
Joined: Thu 14 Aug 2008 12:44

Re: Code first oracle script migrations with many commands

Postby twistyWater » Tue 05 Dec 2017 11:42

Hi, I've sent you a sample of the project, waiting for some news, thanks!
twistyWater
 
Posts: 2
Joined: Wed 29 Nov 2017 15:39

Re: Code first oracle script migrations with many commands

Postby Shalex » Thu 07 Dec 2017 19:57

We have received your test project and are investigating it. We will notify you about the result.
Shalex
Devart Team
 
Posts: 7839
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle