bit data type migration from mssql to postgresql

Anonymous — Fri, 18 Aug 2017 14:49:15 GMT

Good day. I have a next task. I want migrate data from mssql to postgressql without scheme modification. Source database have table with bit type column (Suppose the column is called "BIT_COLUMN_NAME" ). This column must be convert into same bit column of table into target postgresql database.

This generates an error:

Batch entry 0 INSERT INTO ... was aborted. Call getNextException to see the cause.
caused by: ERROR: column "ACTIVER_ENQUETE" is of type bit but expression is of type boolean

type cast: BIT (mssql) -> boolean (talend) -> boolean (talend) -BIT (postgres).

My mapping files:

1) mssql

2) postgresql

Thank you all!

Re: bit data type migration from mssql to postgresql

Anonymous — Wed, 23 Aug 2017 09:48:29 GMT

Hi,

Could you please take a look at this article:https://community.talend.com/t5/Troubleshooting-Development/How-to-process-changing-data-structure/ta-p/21702 to see if this "dynamic schema" feature can meet your needs?

Best regards

Sabrina

topic Re: bit data type migration from mssql to postgresql in Talend Studio

bit data type migration from mssql to postgresql

Re: bit data type migration from mssql to postgresql