Replicating SQL 2000 to PostgreSQL 9.x - Mailing list pgsql-general

From Edson Richter
Subject Replicating SQL 2000 to PostgreSQL 9.x
Date
Msg-id BLU0-SMTP23192AF6CB942C6A6B9ECBACFAC0@phx.gbl
Whole thread Raw
Responses Re: Replicating SQL 2000 to PostgreSQL 9.x  (Edson Richter <edsonrichter@hotmail.com>)
List pgsql-general
I'm trying to setup SQL 2000 replication to PostgreSQL 9.x, and follow
those steps:

1) setup the publisher and distributor in SQL 2000
2) setup the article (12 tables)
3) setup the linked server to PostgreSQL and executed some queries to
test (with success)
4) created the 12 tables in PostgreSQL using correct data types (I've
used Microsoft guide to Oracle compatibility, which seems logical to me)
5) setup the Push Subscriber without creating schema/tables

After few seconds, it fails, and the only error I've have is quite vague
(is a generic "An access violation occurred" error).
I've tried to configure PostgreSQL ODBC driver for logging (without
success: no logs generated).

Is there someone successfully setup SQL 2k to PostgreSQL replication
that could share some thoughts?

Thanks,

Edson


pgsql-general by date:

Previous
From: Pedro Salgueiro
Date:
Subject: Continuous archiving and restore questions
Next
From: Merlin Moncure
Date:
Subject: Re: Re: PostgreSQL specific datatypes very confusing for beginners who use wrappers around JDBC