Liquibase diff for Db2 and postgres DB comparison

General Discussion
1

Hi All,

I am trying to compare two different DB one is DB2 and other postgres, the issue I am facing is in DB2 all the schema and table is in upper letter and in postgres it is in lower case.

if any one has done this there is any way to make it case insensitive comparison.

Use case is we are migrating our DB from Db2 to postgres.

2

Hi @pshankar,

Liquibase doesn’t do that out of the box, but you could create an extension for your particular use case.

You can read more about creating extensions here: Extensions Overview - contribute.liquibase.com

And the particular interface that you’d likely want to implement is here: liquibase 4.21.1 API

- PJ