Re: [GENERAL] Porting from MS Access 2007 to PostgreSQL

2010-11-09 Thread Adrian Klaver
On Monday 08 November 2010 8:22:51 pm Victor Hooi wrote: > Hi, > > Disclaimer: Not a DBA, nor I am not a DB guy, so please excuse any > ignorance in the below. > > *4. MS Access to Postgres* > > Anyhow, somebody else suggested it might be better to just go straight from > the original MS Access da

Re: [GENERAL] Porting from MS Access 2007 to PostgreSQL

2010-11-09 Thread Richard Broersma
On Mon, Nov 8, 2010 at 11:39 PM, Arnaud Lesauvage wrote: > I can't really give you any advice about this, but we kept using Access as > our Frontend and everything runs fine. > You'll just have to make sure that you have read about the 'boolean <-> > integer' problem. This article is a nice start

Re: [GENERAL] Porting from MS Access 2007 to PostgreSQL

2010-11-08 Thread Arnaud Lesauvage
Hi Victor Le 9/11/2010 5:22, Victor Hooi a écrit : Has anybody had any experiencing doing a similar port (Access 2007 to Postgres) recently, what tools did you use, were there any gotchas you hit etc? Or just any general advice at all here? We recently migrated from MSAccess 2000 to PostgreSQL

Re: [GENERAL] Porting from MS Access 2007 to PostgreSQL

2010-11-08 Thread Shoaib Mir
On Tue, Nov 9, 2010 at 3:22 PM, Victor Hooi wrote: > > *4. MS Access to Postgres* > > > Hmm have you tried Kettle (Pentaho) http://kettle.pentaho.com/ > Any particularly good books here that you'd recommend? > http://www.2ndquadrant.com/books/ -- Shoaib Mir http://shoaibmir.wordpress.com/

[GENERAL] Porting from MS Access 2007 to PostgreSQL

2010-11-08 Thread Victor Hooi
Hi, Disclaimer: Not a DBA, nor I am not a DB guy, so please excuse any ignorance in the below. *1. Background* We have a MS Access 2003 database that we are using to manage registration and workshop/accommodation allocation for a conference. The database isn't particularly complicated (around 20