Datatype difference


We recently migrated database from sybase → AWS postgres using SCT/DMS. However we are finding the Sybase datatype CLOB is converted by SCT to text and DMS has migrated the CLOB content in Sybase to plain xml text in postgres.

appreciate any advise/insight on how we move forward on this.

1 Like


Can you describe the data stored in the column?

Can you provide snippets of the data before and after conversion?

Can you provide an example snippet of the desired format after conversion?


1 Like

If CLOB in sybase is just a long text object, and it was migrated to plain xml in PGSQL, then what is the problem? Those sound like the same thing? Or is the data in sybase not xml?

1 Like