1

I have PostgreSQL database in version 9.1 with table that contains column named BinContent configured as BYTEA data type. My target is to migrate/convert this table to Microsoft SQL Server (2008) column configured as IMAGE data type.

When I'm trying to do that conversion i got following error:

OLE DB provider "MSDASQL" for linked server "POSTGRES2" returned message "Requested   conversion is not supported.". 
Msg 7341, Level 16, State 2, Line 1
Cannot get the current row value of column "[MSDASQL].bincontent" from OLE DB provider "MSDASQL" for linked server "POSTGRES2".
Improve this question
4
  • Are you the same person who asked importing a CSV containing an image from MS-SQL into PostgreSQL? Commented May 14, 2014 at 12:30
  • Nope. I don't know that post. Commented May 14, 2014 at 19:37
  • Huh, it must just be import-from-mssql-day. Funny. Can't really help you on this one, as the error seems to be on the MS-SQL side and I haven't used it much at all. Commented May 15, 2014 at 1:48
  • Were you able to find a solution to this question? I have a similar requirement. Commented Jul 28, 2016 at 6:51
Related questions
38
migrate data from MS SQL to PostgreSQL?
9
SQL Server to Postgres
2
SQL Server to PostgreSQL
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.