Replication and varbinary / bytea

Hi

We are attempting to replication from SQl server 2012 to Postgres 9.3

Connectivity and replication are all running fine, however we have a major problem when we stop or start the replication threads.
It 'appears' that when the SQL distribution agent wakes up and reads the MSREPL7 table to see how far it got last time
it has a problem and just resets the xactts count. I think its a problem reading the xactts value - type bytea from the MSREPL7
table.

To reproduce without replication

On Postgres

create table foo (xactts bytea)
insert into foo values ( '\x00019bbe0005a3e8000300000000' )
select * from foo;


Then on SQL
select xactts from dcsrpt01ny.intelligence_100$1.[public].foo

This returns --> 0x5C7830303031396262653030303561336538303030333030303030303030 ??

insert into dcsrpt01ny.intelligence_100$1.[public].foo values (0x00019bbe0005a3e8000300000000 )
--> looks good on Postgres ie reports - x00019bbe0005a3e8000300000000
--> but selecting back from SQL returns - 0x5C7830303031396262653030303561336538303030333030303030303030

I think the strange translation is causing the replication some real problems. Have I missed something on the configuration of the
linked server

Any help would be much appreciated...Replication isn't going to work well at the moment.

Regards
N

Hi,
this looks like a bug. We are looking for a possible fix, and will update this thread...

Thank you!

Hi, Tried some of the older versions of the driver and it seems to work ok in Ver 1.4.0.3264.

Regards

N