Interface MigrationDiff

Schema diff result between the code-first model and the live database.

interface MigrationDiff {
    addColumns: AddColumnDiff[];
    addForeignKeys: AddForeignKeyDiff[];
    addIndexes: AddIndexDiff[];
    alterColumns: AlterColumnDiff[];
    dropColumns: string[];
    dropForeignKeys: string[];
    dropIndexes: string[];
}

Properties

addColumns: AddColumnDiff[]

New column definitions to create.

addForeignKeys: AddForeignKeyDiff[]

New foreign-key constraints to create.

addIndexes: AddIndexDiff[]

New indexes to create.

alterColumns: AlterColumnDiff[]

Existing columns whose attributes must change.

dropColumns: string[]

Physical column names to remove; reviewing these avoids unintended data loss.

dropForeignKeys: string[]

Physical foreign-key constraint names to remove.

dropIndexes: string[]

Physical index names to remove.