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@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
recordin 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