Post reply

Export Image Data from MS SQL Server to PostgreSQL

  • September 28, 2005 at 6:35 am

    #110991

    Hi!

    When I try to export the Data from SQL Server to Postgres(8.0) through DTS, I get the following error message

    "Query-based insertion or updating of BLOB values is not supported."

    Actually the table is having image data type. But while import from Postgres to SQL Server using the same DTS it succeeds.

    I will be very grateful if someone helps to export image data type tables from SQL Server using DTS to Postgres.

    Regards,

    A. Mohan

  • October 24, 2005 at 10:37 am

    #599586

    I am having the same problem trying to export some data to postgres. I am looking for a work around, I believe it is realated to the system dsn settings and having them larger than a certain value causes ms sql to default them to a blob object. If any one has any pointers please help out.

  • October 24, 2005 at 10:56 am

    #599594

    Ok so I got my dts to work, I hope this helps. In your system dsn settings for the db that you are exporting to, (ie i was exporting to postgresql) in Start -> Settings -> Control Panel -> ODBC Sources -> "DSN Name", you need to change the way in which you export the longVarChar. I had mine set to a very large value which was causing this error. If reducing this value doesnt work you may uncheck the "Use LongVarChar for unknown types" box and just use regular varChar with a large value. Hope this helps.

  • October 24, 2005 at 11:31 pm

    #599717

    Thanks for your reply. Like this I have set. Then also it is not working. Any Modifications is required?

    Regards,

    Mohan.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply