RE: MS-Access: MySQL vs. PostgreSQL

From: "Francis Solomon" <francis(at)stellison(dot)co(dot)uk>
To: "Jeff MacDonald" <jeff(at)pgsql(dot)com>, "Hubert Hafner" <public(at)baerndorf(dot)de>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: RE: MS-Access: MySQL vs. PostgreSQL
Date: 2000-11-27 18:31:45
Message-ID: NEBBIFFPELJMCJAODNPKKEEACDAA.francis@stellison.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Hubert,

> I'm not a Access user , but i have dealt with convering applications
> from Access to Postgres. The data swicthing in trivial, either dump it
> or use odbc. But i've never had to play with migrating queries, it
> would probably be in your best interests to rewrite them..

Most query conversion should be trivial, but remember that MS Access
tends to not care about what case your field names are, whereas
PostgreSQL gets pissy if you create a field called SomeCapName and then
try to 'SELECT SomeCapName ...'. You need to 'SELECT "SomeCapName" ...'
instead - or better yet, make sure the converted field names are all
lower case! This goes for other relation names too (tables, etc.)

Do remember, though, that you can phrase crosstab queries in MS Access
(using PIVOT, etc) but you can't do this in PostgreSQL (yet? :). You'd
need to write some form of external program to handle this sort of thing
for you on a query-by-query basis, if you use them in your Access DB.

> How to access store queries ? is it sql, or some mutated
> microsoft mismash ?

MS Access has a QBE (Query-By-Example) grid which is displayed by
default when you open the query definition, but you can flip over into
SQL view very easily (it's on the toolbar). The SQL is reasonably
standard stuff.

If you have problems with specific queries, why not post them here?

Hope this helps.

Francis Solomon

> On Sun, 26 Nov 2000, Hubert Hafner wrote:
>
> > Hi,
> >
> > we have lots of querries (!) and records in our MS-Access-Database.
> > Trying to migrate MDB to MySQL is very difficult because some
> > querries doesn't work anymore (and creating the queeries again
> > is much work)
> > Does anyone know if converting to PostgreSQL is easier?
> >
> > Thanx
> > Hafner Hubert
> >
>
> Jeff MacDonald,

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nelio Alves Pereira Filho 2000-11-27 18:32:31 Help with Procedures in pgsql
Previous Message Tom Lane 2000-11-27 18:17:42 Re: How to keep Postgres from thrashing for a long time using "LIMIT" (or is there a better way?)!