You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
The text was updated successfully, but these errors were encountered:
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
The text was updated successfully, but these errors were encountered: