Replicating SQL 2000 to PostgreSQL 9.x

From: Edson Richter <edsonrichter(at)hotmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Replicating SQL 2000 to PostgreSQL 9.x
Date: 2014-01-29 14:42:31
Message-ID: BLU0-SMTP23192AF6CB942C6A6B9ECBACFAC0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2014-01-29 15:01:36 Re: Re: PostgreSQL specific datatypes very confusing for beginners who use wrappers around JDBC
Previous Message Pedro Salgueiro 2014-01-29 14:15:30 Continuous archiving and restore questions