[Cialug] MS-SQL to Postgres Replication Issues

jcbailey at code0.net jcbailey at code0.net
Tue Aug 1 19:39:20 CDT 2006


I've been having issues doing replication between PQ and MSSQL.. It seems
that the insert for their 'tracking' table is failing since there is a
single quote and backslash on the end. I haven't been able to find
anything on SQL server causing this via Google.. Any thoughts?

<root casemanager 2006-08-01 19:34:11 CDT 1 53751>ERROR:  42P07: relation
"msrepl7" already exists
<root casemanager 2006-08-01 19:34:11 CDT 2 53751>LOCATION: 
heap_create_with_catalog, heap.c:695
<root casemanager 2006-08-01 19:34:11 CDT 3 53751>STATEMENT:  create table
MSrepl7 (pubsrv  text, pubdb  text, publcn   text, indagent bool,subtype
int4, dstagent  text,timecol varchar (23),descr  text, xactts bytea,
updmode int2, agentid  bytea, subguid  bytea, subid  bytea, immsync bool)
<root casemanager 2006-08-01 19:34:11 CDT 4 53755>ERROR:  42601:
unterminated quoted string at or near "'\" at character 125
<root casemanager 2006-08-01 19:34:11 CDT 5 53755>LOCATION:  yyerror,
scan.l:770
<root casemanager 2006-08-01 19:34:11 CDT 6 53755>STATEMENT:  insert into
MSrepl7 values (E'NTSQL', E'Sdata', E'', 0, 0, E'NTSQL-Sdata-CMSLAVE-10',
'2006-08-01 19:33:15'::timestamp, NULL, '\

Used
http://people.planetpostgresql.org/mha/index.php?/archives/87-Replicating-from-MS-SQL-Server-to-PostgreSQL.html
for instructions..


Jon




More information about the Cialug mailing list