Received: from mustang.sdc.com.au (mustang.sdc.com.au [203.2.199.1]) by hub.org (8.9.3/8.9.3) with ESMTP id TAA04042 for ; Wed, 27 Oct 1999 19:01:07 -0400 (EDT) (envelope-from scldad@mustang.sdc.com.au) Received: from mustang.sdc.com.au (localhost [127.0.0.1]) by mustang.sdc.com.au (8.9.1a/8.9.1) with ESMTP id IAA01070; Thu, 28 Oct 1999 08:30:35 +0930 Message-Id: <199910272300.IAA01070@mustang.sdc.com.au> X-Mailer: exmh version 2.0.3 3/23/99 To: Nicolas Huillard cc: "pgsql-interfaces@postgreSQL.org" Subject: Re: [INTERFACES] Replication between MS Access and PostgreSQL In-Reply-To: Message from Nicolas Huillard of "Wed, 27 Oct 1999 15:41:25 +0200." <01BF2091.BB2DF040@agen.int.ghs> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Date: Thu, 28 Oct 1999 08:30:35 +0930 From: Stephen Davies Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id TAA04046 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 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