Best Approach for Migrating Team Calendar Data from MySQL on Server A to PostgreSQL on Server B with

[Ivan Ochoa]

Hi Atlassian community :)

I’m currently managing a Confluence migration, and I need advice on the best method for migrating Team Calendars data from Server A (which uses MySQL) to Server B (which uses PostgreSQL). Here’s the situation:

• Server A: Confluence 8.5.14, Team Calendars, database is MySQL.
• Server B: Confluence 8.5.14, already running with some Team Calendars data, but the database is PostgreSQL.

I want to migrate the calendars from Server A without overwriting the existing data on Server B. My questions are:

1. What is the safest way to extract, transfer, and merge the calendar data between the different database types?
2. How can I avoid data conflicts and ensure all calendars are properly integrated on Server B without disrupting the current calendars?

I appreciate any insights or step-by-step suggestions!