Thread: RE: [INTERFACES] Replication between MS Access and PostgreSQL

RE: [INTERFACES] Replication between MS Access and PostgreSQL

From
Nicolas Huillard
Date:
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:

.... 


Re: [INTERFACES] Replication between MS Access and PostgreSQL

From
Stephen Davies
Date:
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