I have a RDS instance with SQL Server Standard edition. This DB is used for transactions, I want to create read replica but I want the new replica to be MySQL/MariaDB or PostgreSQL. This is because we plan to use reporting software that extracts data directly from our DB.
I don't know if is possible to achieve this. I know that can write some application in some language and use a cron job to execute this every minute but I'm searching a more efficient and elegant solution.
Someone has experience with this? I already read about SymmetricDS but someone has experience with this software and two RDS instances?