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:
<talendType type="id_Boolean" default="true" />
<talendType type="id_Byte" />
<talendType type="id_Integer" />
<talendType type="id_String" />
<talendType type="id_byte" />
<dbType type="BOOL" default="true" />
<dbType type="BIT" />
Thank you all!
Could you please take a look at this article:https://community.talend.com/t5/Troubleshooting-Development/How-to-process-changing-data-structure/t... to see if this "dynamic schema" feature can meet your needs?