3.0 KiB
title, description, tags, peopleInvolved, type_, date, dnb, status, type
| title | description | tags | peopleInvolved | type_ | date | dnb | status | type | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Database Migration (DK) - Sync | null |
|
null | null | 2025-12-03T13:00:00.000Z -> 2025-12-03T13:30:00.000Z | dk | Done | Meeting |
Database Migration (DK) - Sync
event:: Database Migration (DK) - Sync Description: Microsoft Teams Meeting Attendees:
- Paweł Domański (pawel.domanski@outlook.com)
Notes
Mötesanteckningar
Data flow and replication
-
Andrey explained that the current data flow involves daily database replication using a stored procedure in the master database, which caused issues when moving to the test environment.
-
Andrey identified how the application reads data from the database and proposed eliminating the need for database replication, but emphasized that thorough testing is still required before making changes.
Migration blockers
-
Paweł agreed to help Andrey recreate the stored procedure in the test environment, but mentioned that it is a blocker for the upcoming migration.
-
Paweł stated that the server is not ready and lacks necessary system information, which is another blocker for migration.
-
Paweł stated they need additional time to configure and review the procedures related to the database setup.
-
Andrey explained that the lack of documentation and internal knowledge is making the application testing and migration process more challenging
Migration planning
-
Andrey indicated that migration will not happen next week due to these obstacles and suggested removing the need for database replication by consolidating to a single database server.
-
Naser proposed setting January 31st as the target date for completing application testing and migration, with flexibility to finish earlier if possible
Data preparation
- Andrey stated they are progressing with data manipulation scripts and will spend this and next week setting up and deploying them as a Kubernetes job
Testing requirements
- Andrey emphasized the need for thorough application testing to ensure all functionality works correctly after the database changes
Uppföljningsuppgifter
| Uppgift | Tilldelats till | Förfallodatum | Hink |
|---|---|---|---|
| Test the application with the new database setup to confirm it reads data correctly and safely before removing replication (Andrey) | |||
| Set a preliminary migration date for the end of January, with the final date to be confirmed after testing is complete (Naser, Andrey, Paweł) | |||
| Request firewall opening for the server to enable database access for applications (Andrey) |