Devart Forums

Code: Select all

Update-Database -Verbose -ProjectName MyProject  -ConnectionString "xxx" -ConnectionProviderName "Devart.Data.Oracle" -Script

Code: Select all

ALTER TABLE USER.BOX_VERSIONS
MODIFY CREATION_DATE TIMESTAMP(0) WITH TIME ZONE DEFAULT NULL

/

DECLARE

Code: Select all

ALTER TABLE USER.BOX_VERSIONS
MODIFY CREATION_DATE TIMESTAMP(0) WITH TIME ZONE DEFAULT NULL
  EXECUTE IMMEDIATE 'ALTER TABLE USER.BOX_VERSIONS MODIFY CREATION_DATE NOT NULL';
EXCEPTION
  WHEN OTHERS THEN
    IF SQLCODE <> -1451 AND SQLCODE <> -1442 THEN
      RAISE;
    END IF;
END;
/

DECLARE
  BINARY_VALUE BLOB;
BEGIN
  DBMS_LOB.CREATETEMPORARY(BINARY_VALUE, TRUE);
  DBMS_LOB.APPEND(BINARY_VALUE, TO_BLOB(CAST('...' AS LONG RAW)));
  INSERT INTO USER."__MigrationHistory" ("MigrationId", "ContextKey", "Model", "ProductVersion") VALUES ('202109080628292_Test', 'Qm.Tda.Dal.Migrations.Configuration', BINARY_VALUE, '6.4.4');
END;

Code: Select all

-- Script was generated by Devart dotConnect for Oracle, Version 9.14.1382
-- Product home page: http://www.devart.com/dotconnect/oracle
-- Database version: Oracle 12.1.0.2
-- Script date 11.11.2021 11:33:30

BEGIN
/

CREATE UNIQUE INDEX UT_ARIANE.IX_1390940320 ON UT_ARIANE.BOX_LOTS (BOX_ID, BOX_VERSION_NO, LABEL)
/

DECLARE
  BINARY_VALUE BLOB;
BEGIN
  DBMS_LOB.CREATETEMPORARY(BINARY_VALUE, TRUE);
  .
  .
  .
  INSERT INTO UT_ARIANE."__MigrationHistory" ("MigrationId", "ContextKey", "Model", "ProductVersion") VALUES ('202111111031023_Test', 'Tests.Migrations.Configuration', BINARY_VALUE, '6.4.4');
END;
/

Code: Select all

Applying explicit migrations: [202111111031023_Test].
Applying explicit migration: 202111111031023_Test.
  FOR c IN (
    SELECT INDEX_OWNER, INDEX_NAME
      FROM SYS.ALL_IND_COLUMNS
    WHERE TABLE_OWNER = 'UT_ARIANE' AND TABLE_NAME = 'BOX_LOTS' AND COLUMN_NAME IN ('BOX_ID', 'BOX_VERSION_NO', 'ID')
    HAVING COUNT(*) = 3
    GROUP BY INDEX_OWNER, INDEX_NAME
  )
  LOOP
    SYS.DBMS_UTILITY.EXEC_DDL_STATEMENT(
      'DROP INDEX "' || c.INDEX_OWNER || '"."' || c.INDEX_NAME || '"'
    );
  END LOOP;
END;