Uploaded image for project: 'Bitrepository'
  1. Bitrepository
  2. BITMAG-1017

Automatic and semi-automatic database migration test

    XMLWordPrintable

Details

    • Bit Sprint 1

    Description

      We should automate the migration of databases in for both services and reference pillar.
      As derby and postgres are rather different (in terms of deployment) two methods are proposed:

      • Derby:
        Store the 'oldest database schema that we can migrate from' along with the contemporary schema and all the migration scripts.
        Create a test that initially creates a database based on the old schema, and see that it can migrate through all the versions.
      • Postgres:
        On the regulus env. where we have a postgres server, a script should be created that can nuke the database in two possible ways.
        1) clean the database and put the contemporary schema on the database
        2) clean the database and put the oldest migrateable schema on, run all the schema migrations.
        For both scenarios, the services should be able to start-up with no fuzz

      Attachments

        Activity

          People

            Unassigned Unassigned
            ktc Kim Christensen (Inactive)
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: