From: Stephen Davies <scldad@sdc.com.au>
To: Nicolas Huillard <nhuillard@ghs.fr>
Cc: pgsql-interfaces@postgreSQL.org <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] Replication between MS Access and PostgreSQL
Date: Thu, 28 Oct 1999 08:30:35 +0930
Message-ID: <199910272300.IAA01070@mustang.sdc.com.au> (raw)
In-Reply-To: <nhuillard@ghs.fr> <01BF2091.BB2DF040@agen.int.ghs>
G'day Nicholas.
You might like to look at the contents of ftp://ftp.sdc.com.au/pub/repl.
It is a general purpose database replicator for any pair of databases which
inderstand ODBC.
Cheers,
Stephen.
Nicolas Huillard <nhuillard@ghs.fr> wrote:
> This description is a way to export tables from Access to Postgres. I know how to do this.
> What I'm looking for is a tool to synchronize the data between the same table inside Access and Postgres, ie : a new record in Postgres should be transfered to Access, and the same the other way.
>
> Thanks.
>
> -----Message d'origine-----
> De: Allan Huffman [SMTP:huffmana@ppc.pims.org]
> Date: mercredi 27 octobre 1999 15:25
> À: Nicolas Huillard; pgsql-interfaces@postgreSQL.org
> Objet: Re: [INTERFACES] Replication between MS Access and PostgreSQL
>
> You can export the MS Access tables to Postgres as long as the ODBS.exe has been run and set up from the
> control panel "32 ODBC" configuration panels that are loaded from the .exe. You will need the Host name,
> database name, User and Password, and use the default PostgreSQL Postmaster port number. The Postmaster
> has to be running with the database allocated but the table must not already exit. Then do the following:
>
> ....
>
> ************
--
========================================================================
Stephen Davies Consulting scldad@sdc.com.au
Adelaide, South Australia. Voice: 08-8177 1595
Computing & Network solutions. Fax: 08-8177 0133
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: scldad@sdc.com.au, nhuillard@ghs.fr
Subject: Re: [INTERFACES] Replication between MS Access and PostgreSQL
In-Reply-To: <199910272300.IAA01070@mustang.sdc.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox