maykinmedia / open-klant

Registratiecomponent voor de opslag en ontsluiting van klantgegevens volgens de Klantinteracties API-specificatie.
Other
2 stars 3 forks source link

Develop OK v1 to OKv2 Klanten migration script #197

Closed alextreme closed 3 days ago

alextreme commented 5 months ago

Thema / Theme

Other

Omschrijving / Description

Taiga DH 579

A script to migrate the Open Klant v1 Klanten to Open Klant v2 has been requested, for further details of which fields are to be migrated see the Taiga issue

Toegevoegde waarde / Added value

No response

Aanvullende opmerkingen / Additional context

No response

joeribekker commented 4 months ago

Estimated on 5 days

joeribekker commented 4 months ago

@JanBrek ping

PeterVanBragt commented 4 months ago

At first glance, 5 days seems like a lot of work for a query. Can some more background information be provided on this?

joeribekker commented 4 months ago

@PeterVanBragt it's 2 different databases, so just a query won't cut it. Let's not downplay the work involved here.

However, if the scope is limited to "klanten" to be migrated to "partijen" (explicitly saved) and leave out "klanten" (ad hoc saved), things will be little easier since we don't need much logic. The tables however are really different, so we need to export it and then when importing, scatter the data over various tables.

There was a reason Open Klant had a major version bump. The data is not really compatible.

So. Maybe 4 days if no logic do distinct between partijen and klanten.

PeterVanBragt commented 3 months ago

Hi @joeribekker, I can hereby approve this issue!

alextreme commented 1 week ago

Discussed, migration script will be rounded up and an Open Klant release with it will be ready before the end of november