Before going forward we list out bottlenecks while migrating
from MySQL to Postgres
Data types are different in Postgres than
what we have in MySQL If
we have few tables to migrate we can convert
MySQL dump(.sql) file to Postgres query using any tool such as
pgloader but if the data is huge let’s say 4-5 GB, We won’t be
I've worked with clients that, for one reason or another, needed to change their database platform.
This ask has increased with the move to DXPCloud and MySQL database.
I'm not sure there's a well defined plan for how to migrate a Liferay database, so I thought I'd blog about it.
Now, if you know anything about me, you know I'm a planner and I create (sometimes intricate)...