Using Pgloader to transfer data from a MSSQL source to a postgresql destination, I'm facing a truncation of the data transfered from a field
nvarchar(2147483647) in MSSQL to a text field (Definition of the field are done by the application using the database)
All the value exceeding a length of 2048 are truncated to this size.
With an update / direct insert of the value, the destination column is well storing the data, so it looks like it's not a field size limitation in the destination.
I tried set a parameter "text size = 10000000000000" in the section [source] of the /etc/freetds/freetds.conf file but no impact.
Do you have an idea of the origin of this limitation and where increase it ?
Thanks
Hello,
Using Pgloader to transfer data from a MSSQL source to a postgresql destination, I'm facing a truncation of the data transfered from a field nvarchar(2147483647) in MSSQL to a text field (Definition of the field are done by the application using the database)
All the value exceeding a length of 2048 are truncated to this size.
With an update / direct insert of the value, the destination column is well storing the data, so it looks like it's not a field size limitation in the destination.
I tried set a parameter "text size = 10000000000000" in the section [source] of the /etc/freetds/freetds.conf file but no impact.
Do you have an idea of the origin of this limitation and where increase it ? Thanks
Loïc