Replicating Binary Data from MS SQL 2000 to PG 8.2

From: "Mike Poe" <trolling4dollars(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Replicating Binary Data from MS SQL 2000 to PG 8.2
Date: 2007-01-21 13:13:58
Message-ID: 50e63fc50701210513p2eae9a12l2ff4ad6fb2f038e7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have set up replication between a SQL 2000 server & a PG 8.2.0-1
server (both running on Windows 2003). To date, I've been replicating
four tables from a database with no problem whatsoever.

I'm attempting to replicate a fifth table, which isn't working so well.

The designer of the SQL 2000 database decided to store binary data
(images) directly in this table. When I attempt to replicate it to my
PG database, SQL replication agent throws an error:

The process encountered invalid column data in bcp file 'path\to\bcpfile.bcp'.

I assume this has to do with the binary data in the table.

FWIW, I'm able to successfully replicate this table to other SQL 2000 databases.

Is anyone replicating binary data from SQL 2000 to PG, and if so, what
exactly did you do to make it work? There's next to nothing on the
internet about the error I'm getting... and my feeble attempts so far
have failed to fix the problem.

Thanks!
Mike

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2007-01-21 13:16:37 Re: Password encryption method
Previous Message imageguy 2007-01-21 12:56:23 Using transactions with plpythonu