Code first oracle script migrations with many commands
Posted: Wed 29 Nov 2017 16:43
When I generate an initial script with multiple tables creation, there is no delimiter for each oracle commands :
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
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)
We are using dotConnect for Oracle 9.5.399
Thank you