Limitation for Oracle to PostgreSql using Database Migration Service (DMS)

[PraveenKvs]

Hi,

There is a limitation in Database Migration Service (DMS) when we migrate Oracle tables to PostgreSql. Rows that exceed 30MB limit are not migrated and show up as errors in the migration job. 

So, I am looking for an efficient workaround to get rid of such scenarios. 

Can anyone please help me with a right solution?

[mcbsalceda]

Hi @PraveenKvs,

Welcome to Google Cloud Community!

Migrating data from Oracle to PostgreSQL using Google Cloud Platform’s Database Migration Service (DMS) may present challenges, particularly with large rows that exceed the 30MB limit. It might be worthwhile to explore preprocessing your data by dividing large rows into smaller chunks to fit within this constraint. Afterward, you could attempt to migrate these chunks using DMS and then reconstruct the original rows in PostgreSQL post-migration. 

If these approaches do not fully resolve the issue or if you need additional guidance, contacting Google Cloud Support might offer further assistance.

I hope the above information is helpful.