Replication and varbinary / bytea

More
5 years 9 months ago #12628 by davies
davies created the topic: 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

Please Log in or Create an account to join the conversation.

More
5 years 9 months ago #12630 by Moderator
Moderator replied the topic: Re: Replication and varbinary / bytea
Hi,
this looks like a bug. We are looking for a possible fix, and will update this thread...

Thank you!

Please Log in or Create an account to join the conversation.

More
5 years 8 months ago #12645 by davies
davies replied the topic: Re: Replication and varbinary / bytea
Hi, Tried some of the older versions of the driver and it seems to work ok in Ver 1.4.0.3264.

Regards

N

Please Log in or Create an account to join the conversation.

Time to create page: 0.064 seconds
Powered by Kunena Forum