RelationalDatabaseUpgrade

The set of Relational Upgrade steps to describe what schema changes took place in this version

Properties

dataSource : string

Data source name.

description : string

Data source upgrade description.

version : string

Unique string identifying the repository version. Empty for virtual upgrade steps providing context for subsequent steps.

Content

• Choice of:

  • CreateTable [1..1] - Add a new table to the schema.

  • AlterTable [1..1] - Modify an existing table.

  • RenameTable [1..1] - Rename an existing table.

  • DropTable [1..1] - Drop an existing table from the schema.

  • ApplyTableAspect [1..1] - Apply a new Table Aspect to an existing table.

  • RemoveTableAspect [1..1] - Remove a Table Aspect from an existing table.

  • CreateColumn [1..1] - Add a new column to an existing table.

  • AlterColumn [1..1] - Change an existing column in a table.

  • RenameColumn [1..1] - Rename an existing column in a table.

  • DropColumn [1..1] - Drop an existing column from a table.

  • CreateIndex [1..1] - Add a new index to a table.

  • RenameIndex [1..1] - Rename an existing table index.

  • DropIndex [1..1] - Drop an index from an existing table.

  • ApplyIndexAspect [1..1] - Apply a new IndexAspect to a table.

  • RemoveIndexAspect [1..1] - Remove an existing IndexAspect from a table.

  • CreateObject [1..1] - Create a new stored procedure in the schema.

  • DropObject [1..1] - Drop an existing stored procedure from the schema.

  • Exec [1..1] - Execute some DML statements against the database.

  • SupportAdapter [1..1] - Add support for a new Relational Database Adapter from this point forward.

  • MoveData [1..1] - Apply a move action (select, insert, delete) to some data.

Parents

• Upgrade - The set of changes to a model's Relational Datasource(s) from version to version.