Start a new topic
Solved

Error when performing Data Pump from SQLite till MSSQL

When pumping DB below from sqlite to mssql, the process fails. Interestingly, it was just pumped from mssql to sqlite, so a roundtrip is not possible. Attaching screenshot of error. 


odbc.png
(168 KB)
1 Comment

The error seems to reside with the ODBC driver and not the server. The object causing the import to fail has a blob that is 490k which is larger than other objects but entirely manageable from a database perspective. Upgrading to Microsoft® ODBC Driver 11 for SQL Server® - Windows (https://www.microsoft.com/en-us/download/details.aspx?id=36434) should resolve the issue. 

Login to post a comment