pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedReplication between MS Access and PostgreSQL
9+ messages / 8 participants
[nested] [flat]
* Replication between MS Access and PostgreSQL
@ 1999-10-27 09:38 Nicolas Huillard <nhuillard@ghs.fr>
0 siblings, 1 reply; 9+ messages in thread
From: Nicolas Huillard @ 1999-10-27 09:38 UTC (permalink / raw)
To: pgsql-interfaces
Hello,
Are there any tools on earth that allow replication between an Access database and a PostgreSQL server ?
I think about things like :
* standalone Windows app that have two ODBC connections and replicate data between the two,
* VBA modules to insert in the Access database,
* other stuff,
I don't necessarily need a true replication. If there are a few impossible things, I could still be OK.
TIA,
Nicolas Huillard
G.H.S
Directeur Technique
Tél : +33 1 43 21 16 66
Fax : +33 1 56 54 02 18
mailto:nhuillard@ghs.fr
http://www.ghs.fr
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [INTERFACES] Replication between MS Access and PostgreSQL
@ 1999-10-27 13:25 Allan Huffman <huffmana@ppc.pims.org>
parent: Nicolas Huillard <nhuillard@ghs.fr>
0 siblings, 0 replies; 9+ messages in thread
From: Allan Huffman @ 1999-10-27 13:25 UTC (permalink / raw)
To: Nicolas Huillard <nhuillard@ghs.fr>; pgsql-interfaces
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:
1) File select "Export as"
2) To an External File or Database
3) Change the "Save as type" to ODBC Databases()
4) Verify the name (all lower case) and click OK
5) Select "DSN Name" to be "MS Access 97 Databases (not sharable).dsn"
6) Click OK
All table names and column names must be lower case (at least for PostgreSQL 6.5.2 running on Solaris).
Cheers,
Allan
Nicolas Huillard wrote:
> Hello,
>
> Are there any tools on earth that allow replication between an Access database and a PostgreSQL server ?
> I think about things like :
> * standalone Windows app that have two ODBC connections and replicate data between the two,
> * VBA modules to insert in the Access database,
> * other stuff,
> I don't necessarily need a true replication. If there are a few impossible things, I could still be OK.
>
> TIA,
>
> Nicolas Huillard
> G.H.S
> Directeur Technique
> Tél : +33 1 43 21 16 66
> Fax : +33 1 56 54 02 18
> mailto:nhuillard@ghs.fr
> http://www.ghs.fr
>
> ************
^ permalink raw reply [nested|flat] 9+ messages in thread
* RE: [INTERFACES] Replication between MS Access and PostgreSQL
@ 1999-10-27 13:41 Nicolas Huillard <nhuillard@ghs.fr>
0 siblings, 1 reply; 9+ messages in thread
From: Nicolas Huillard @ 1999-10-27 13:41 UTC (permalink / raw)
To: pgsql-interfaces
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:
....
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [INTERFACES] Replication between MS Access and PostgreSQL
@ 1999-10-27 23:00 Stephen Davies <scldad@sdc.com.au>
parent: Nicolas Huillard <nhuillard@ghs.fr>
0 siblings, 0 replies; 9+ messages in thread
From: Stephen Davies @ 1999-10-27 23:00 UTC (permalink / raw)
To: Nicolas Huillard <nhuillard@ghs.fr>; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [INTERFACES] Replication between MS Access and PostgreSQL
@ 1999-10-28 07:46 Alain.Tesio@sip.fr
0 siblings, 0 replies; 9+ messages in thread
From: Alain.Tesio@sip.fr @ 1999-10-28 07:46 UTC (permalink / raw)
To: Nicolas Huillard <nhuillard@ghs.fr>; pgsql-interfaces
--- 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.
If you only need to transfer new rows and don't care about
updated or deleted rows, it's pretty easy to do, especially if you
have an identifier in your table generated by a sequence
(or the date it was inserted).
in Postgres :
table DATA (rowid, other_columns), index on rowid
table LAST_CHECK (rowid) -- one row in this table
select @rowid1=rowid from LAST_CHECK
select @rowid2=max(rowid) from DATA
select * from DATA where @rowid1 < rowid <= @rowid2
update from LAST_CHECK set rowid=@rowid2
(Sybase-like syntax for variables, sorry ...)
And something similar in Access.
You must have a cron job which runs this script periodically
and insert the resultset from the third instruction into Access.
It doesn't need to be transactional.
The both databases should generate identifiers on non-overlapping
ranges, for example negative in Access, replace max by min for the
other script and reverse the comparison order.
Alain
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [INTERFACES] Replication between MS Access and PostgreSQL
@ 1999-10-28 09:11 Alain TESIO <alain_tesio@yahoo.com>
0 siblings, 0 replies; 9+ messages in thread
From: Alain TESIO @ 1999-10-28 09:11 UTC (permalink / raw)
To: pgsql-interfaces
--- 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.
If you only need to transfer new rows and don't care about
updated or deleted rows, it's pretty easy to do, especially if you
have an identifier in your table generated by a sequence
(or the date it was inserted).
in Postgres :
table DATA (rowid, other_columns), index on rowid
table LAST_CHECK (rowid) -- one row in this table
select @rowid1=rowid from LAST_CHECK
select @rowid2=max(rowid) from DATA
select * from DATA where @rowid1 < rowid <= @rowid2
update from LAST_CHECK set rowid=@rowid2
(Sybase-like syntax for variables, sorry ...)
And something similar in Access.
You must have a cron job which runs this script periodically
and insert the resultset from the third instruction into Access.
It doesn't need to be transactional.
The both databases should generate identifiers on non-overlapping
ranges, for example negative in Access, replace max by min for the
other script and reverse the comparison order.
Alain
=====
signoff
__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com
^ permalink raw reply [nested|flat] 9+ messages in thread
* Replication between MS-Access and PostgreSQL
@ 2000-09-20 18:22 philippe.benaiche@fr.abb.com
0 siblings, 2 replies; 9+ messages in thread
From: philippe.benaiche@fr.abb.com @ 2000-09-20 18:22 UTC (permalink / raw)
To: pgsql-interfaces
Hi everybody,
Find below an URL in order to download the source code of a VB application
to do a great work : replication...
http://www.ghs.fr/download/postgres2access_replicator.zip
This link has been prvovide by :Nicolas Huillard
^ permalink raw reply [nested|flat] 9+ messages in thread
* RE: Replication between MS-Access and PostgreSQL
@ 2000-09-21 12:26 Oscar Serrano <oserra@fondos.net>
parent: philippe.benaiche@fr.abb.com
1 sibling, 0 replies; 9+ messages in thread
From: Oscar Serrano @ 2000-09-21 12:26 UTC (permalink / raw)
To: philippe.benaiche@fr.abb.com; pgsql-interfaces
> -----Mensaje original-----
> De: pgsql-interfaces-owner@hub.org
> [mailto:pgsql-interfaces-owner@hub.org]En nombre de
> philippe.benaiche@fr.abb.com
> Enviado el: miercoles, 20 de septiembre de 2000 20:23
> Para: pgsql-interfaces@postgresql.org
> Asunto: [INTERFACES] Replication between MS-Access and PostgreSQL
>
>
>
>
> Hi everybody,
>
> Find below an URL in order to download the source code of a VB application
> to do a great work : replication...
> http://www.ghs.fr/download/postgres2access_replicator.zip
> This link has been prvovide by :Nicolas Huillard
It doesn't work. I can't find the URL www.ghs.fr :-?
thanks.
>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* RE: Replication between MS-Access and PostgreSQL
@ 2000-09-21 18:38 Doug Budny <bunji@stuffedmonkey.com>
parent: philippe.benaiche@fr.abb.com
1 sibling, 0 replies; 9+ messages in thread
From: Doug Budny @ 2000-09-21 18:38 UTC (permalink / raw)
To: pgsql-interfaces
I tried using the ip addr 195.154.101.195 and get "Forbidden:You don't have
permission to access / on this server." Even adding the rest of the url
gives me a similar error. Is the site not setup properly or can we just
not access it from the US?
At 9/21/2000 02:26 PM, you wrote:
> > -----Mensaje original-----
> > De: pgsql-interfaces-owner@hub.org
> > [mailto:pgsql-interfaces-owner@hub.org]En nombre de
> > philippe.benaiche@fr.abb.com
> > Enviado el: miercoles, 20 de septiembre de 2000 20:23
> > Para: pgsql-interfaces@postgresql.org
> > Asunto: [INTERFACES] Replication between MS-Access and PostgreSQL
> >
> >
> >
> >
> > Hi everybody,
> >
> > Find below an URL in order to download the source code of a VB application
> > to do a great work : replication...
> > http://www.ghs.fr/download/postgres2access_replicator.zip
> > This link has been prvovide by :Nicolas Huillard
>
>
>It doesn't work. I can't find the URL www.ghs.fr :-?
>thanks.
>
>
> >
> >
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2000-09-21 18:38 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-10-27 09:38 Replication between MS Access and PostgreSQL Nicolas Huillard <nhuillard@ghs.fr>
1999-10-27 13:25 ` Allan Huffman <huffmana@ppc.pims.org>
1999-10-27 13:41 RE: [INTERFACES] Replication between MS Access and PostgreSQL Nicolas Huillard <nhuillard@ghs.fr>
1999-10-27 23:00 ` Stephen Davies <scldad@sdc.com.au>
1999-10-28 07:46 Re: [INTERFACES] Replication between MS Access and PostgreSQL Alain.Tesio@sip.fr
1999-10-28 09:11 Re: [INTERFACES] Replication between MS Access and PostgreSQL Alain TESIO <alain_tesio@yahoo.com>
2000-09-20 18:22 Replication between MS-Access and PostgreSQL philippe.benaiche@fr.abb.com
2000-09-21 12:26 ` RE: Replication between MS-Access and PostgreSQL Oscar Serrano <oserra@fondos.net>
2000-09-21 18:38 ` RE: Replication between MS-Access and PostgreSQL Doug Budny <bunji@stuffedmonkey.com>
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