- Forum
- Main PGNP Forum
- SQL Server/DTS/SSIS/Linked servers/Replication
- Replication and varbinary / bytea
Replication and varbinary / bytea
- davies
- Topic Author
- Visitor
-
8 years 2 months ago #12628
by davies
Replication and varbinary / bytea was created by davies
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
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.
8 years 2 months ago #12630
by Moderator
Replied by Moderator on 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!
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.
- davies
- Topic Author
- Visitor
-
8 years 2 months ago #12645
by davies
Replied by davies on 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
Regards
N
Please Log in or Create an account to join the conversation.
- Forum
- Main PGNP Forum
- SQL Server/DTS/SSIS/Linked servers/Replication
- Replication and varbinary / bytea
Time to create page: 0.053 seconds
- You are here:
-
Home
-
Forum
-
Main PGNP Forum
-
SQL Server/DTS/SSIS/Linked servers/Replication
- Replication and varbinary / bytea