Can Script-Migration create script for Oracle?
Posted: Thu 27 Sep 2018 19:11
I'm using dotConnect Oracle and EF Core 2 Code First Migrations. If I use Update-Database, migrations are applied correctly to the database. However, if I use Script-Migration, the generated SQL is for SQL Server, not Oracle. For example:
and
How can I script the migration for Oracle?
Thanks.
Code: Select all
IF OBJECT_ID(N'[__EFMigrationsHistory]') IS NULL
BEGIN
CREATE TABLE [__EFMigrationsHistory] (
[MigrationId] nvarchar(150) NOT NULL,
[ProductVersion] nvarchar(32) NOT NULL,
CONSTRAINT [PK___EFMigrationsHistory] PRIMARY KEY ([MigrationId])
);
END;
Code: Select all
SET IDENTITY_INSERT [Lookup] OFF;
Thanks.