Re: [GENERAL] Replicating Binary Data from MS SQL 2000 to PG 8.2

2007-01-22 Thread Richard Huxton
Mike Poe wrote: 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

[GENERAL] Replicating Binary Data from MS SQL 2000 to PG 8.2

2007-01-21 Thread Mike Poe
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 SQ