t_Upgrade_RelationalDatabaseUpgrade

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:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • t_RelationalDatabaseUpgrade_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.

• t_RelationalDatabaseUpgrade_CreateTable
  Add a new table to the schema.

• t_RelationalDatabaseUpgrade_AlterTable
  Modify an existing table.

• t_RelationalDatabaseUpgrade_RenameTable
  Rename an existing table.

• t_RelationalDatabaseUpgrade_DropTable
  Drop an existing table from the schema.

• t_RelationalDatabaseUpgrade_ApplyTableAspect
  Apply a new Table Aspect to an existing table.

• t_RelationalDatabaseUpgrade_RemoveTableAspect
  Remove a Table Aspect from an existing table.

• t_RelationalDatabaseUpgrade_CreateColumn
  Add a new column to an existing table.

• t_RelationalDatabaseUpgrade_AlterColumn
  Change an existing column in a table.

• t_RelationalDatabaseUpgrade_RenameColumn
  Rename an existing column in a table.

• t_RelationalDatabaseUpgrade_DropColumn
  Drop an existing column from a table.

• t_RelationalDatabaseUpgrade_CreateIndex
  Add a new index to a table.

• t_RelationalDatabaseUpgrade_RenameIndex
  Rename an existing table index.

• t_RelationalDatabaseUpgrade_DropIndex
  Drop an index from an existing table.

• t_RelationalDatabaseUpgrade_ApplyIndexAspect
  Apply a new IndexAspect to a table.

• t_RelationalDatabaseUpgrade_RemoveIndexAspect
  Remove an existing IndexAspect from a table.

• t_RelationalDatabaseUpgrade_CreateObject
  Create a new stored procedure in the schema.

• t_RelationalDatabaseUpgrade_DropObject
  Drop an existing stored procedure from the schema.

• t_RelationalDatabaseUpgrade_Exec
  Execute some DML statements against the database.

• t_RelationalDatabaseUpgrade_SupportAdapter
  Add support for a new Relational Database Adapter from this point forward.

• t_RelationalDatabaseUpgrade_MoveData
  Apply a move action (select, insert, delete) to some data.

Parent topic: Upgrade