Solution shall use PostgresSQL and Flyway

[ecruz165]

The solution should be migrated to a open source database like Postgres. Before performance issues were seen and that is why MS SQL was chosen.

Expection:

• Create performance test script to collect some performance numbers against MS SQL
• create sql files to drop and create schema and tables
• create sql files to drop and, create indexes
• create sql files to delete and insert data
• Decide on Liquibase or Flyway to apply sql
• Create container to host Postgres
• Configure DB Change management to apply SQL.
• Update/test docker compose file
• Test configuration against application
• Run performance test scripts against Postgres.

Definition of Done:

• Docker deployment includes Postgres and at least matches current performance