Using AWS DMS to migrate MariaDB to PostgreSQL
To mitigate this problem my team and I decided to use AWS Database Migration Service (AWS DMS) to migrate two tables of the main database (MariaDB) to another database (PostgreSQL). This is a summary of how we achieve that and some personal notes that can help you if you are to do this.