Posted by: Anonymous Coward
on May 24, 2004 12:20 AM
> what did your brother replace Access with?
His database is not overly complex, and he originally programmed it himself. He migrated the data to MySQL (though I was pushing for PostgreSQL<nobr> <wbr></nobr>:-).
Migrating the data was fairly simple -- define the new tables, and then just export and import. The front-end queries, however, are more complicated.
Initially, for the front end, I helped him set up some rudimentary web-based queries using PHP.
We also used <A HREF="http://www.phpmyadmin.net/home_page/" title="phpmyadmin.net">phpMyAdmin</a phpmyadmin.net> (or <A HREF="http://sourceforge.net/projects/phpmyadmin/" title="sourceforge.net">here</a sourceforge.net>) to create and manage his MySQL tables.
He hasn't set up his local front-end yet, though he will probably be using the database software that comes with StarOffice.
I haven't used it myself, but I see from the <A HREF="http://wwws.sun.com/software/star/staroffice/faq.html#1q7" title="sun.com">StarOffice FAQ</a sun.com> that it now comes with the <A HREF="http://www2.softwareag.com/Corporate/products/adabas/default.asp" title="softwareag.com">Adabas Database</a softwareag.com>.
I had also suggested a few other alternatives, such as:
- A custom-written front-end using the Mozilla toolkit. - A custom-written front-end using Gnome (since JDS is Gnome-based). - GnomeDB (though I don't know how far along that project is). - The database access capabilities of OpenOffice (though they're quite rudimentary).