OrmLite Migrations

[mythz]

OrmLite doesn’t contain any data migration solutions itself but you can read about different approaches taken in:

Any recommendations for maintaining database schemas?

During development it is not uncommon for database tables to change design overtime, both in terms of add/remove/change of columns as the data model evolves. Unfortunately, doing a CreateTable if not existing, or DropCreate is not always an option … I coded a semi-smart AlterTable<T> to add new columns, but a long-term migration/versioning path is needed. Any recommendations on how best to maintain versioned SQL update files (something like https://flywaydb.org) or ideally something that can l…

In addition to dropping and recreating table schemas, OrmLite also includes Modify Schema API’s, e.g. for adding/removing individual columns. There are additional APIs in the OrmLiteSchemaModifyApi class:

• AlterTable
• AddColumn
• AlterColumn
• ChangeColumnName
• DropColumn
• AddForeignKey
• DropForeignKey
• CreateIndex
• DropIndex