27/08/2024 RESDiary Migration Script

The old data bridge is to be disabled. When new configurations go live, this migration script can be run for each listed account. A lean UI is provided to trigger the process.

Data Fix 🪛

1. Identify bookings without a provider ID

2. Alter identified rows sobooking_data_element_01 = booking_reference , booking_data_element_02 = booking_data_element_01 , booking_data_element_02 = NULL

3. Update provider ID to RESDiary ID

👨‍💻 Russ Chandler