I'm trying to move our database from a mysql rds to postgresql rds, the current database is currently setup on rds, so we are using auroroa for mysql, i found out that aws has a Data Migration service that i can use to live move data to the new postgresql rds with minimum downtime, since this is going to be used on production, we need as minimum of a downtime as possible, i also found that this DMS service does not properly move the schema, so i'm trying to use aws SCT to convert the schema to the new postgresql database first, unfortunately, this is not going smoothly, since during the conversion, i faced an error when SCT tried to convert data types like json, as fat as i know postgresql does support json data type, still my SQL knowledge is not that great, so i'm not sure what is the problem here, is it possible that aws aurora postgresql does not support json datatype ? though, the aws documentation says otherwise, anyway, i will provide a screenshot to show the error, and i'm hoping someone can help me convert this manually or even suggesst a better approach to moving a database from mysql to postgresql.
Thank you,
Asked
Active
Viewed 48 times
0
logax
- 33
- 6