Re: [INTERFACES] Replication between MS Access and PostgreSQL

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(at)ghs(dot)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(at)ppc(dot)pims(dot)org]
> Date: mercredi 27 octobre 1999 15:25
> À: Nicolas Huillard; pgsql-interfaces(at)postgreSQL(dot)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(at)sdc(dot)com(dot)au
Adelaide, South Australia. Voice: 08-8177 1595
Computing & Network solutions. Fax: 08-8177 0133