For simple personal use I would recommend MySQL. You can easily export each
table out of MS Access and import into MySQL, or link the MySQL tables in
access and run an append query to transfer the information between the
access tables and the MySQL tables. 

-----Original Message-----
From: plug-discuss-bounces@lists.plug.phoenix.az.us
[mailto:plug-discuss-bounces@lists.plug.phoenix.az.us] On Behalf Of mz
Sent: Tuesday, March 31, 2009 9:58 AM
To: Main PLUG discussion list
Subject: looking for db recommendation

I'm migrating from M$ WinXP to openSUSE 11.0. At the moment I'm looking for
a db for simple personal use.

I have a music collection db in M$ Access. There are about 1900 records w/
six variables. The collection is mostly vinyl LPs (i.e., entered by
hand) with another 2000 LPs not yet in the db. If possible, I'd like to do a
simple import w/ minimal clean up to avoid re-entering the existing records.

What are the recommendations for a db and how best to accomplish the
migration?

TIA,
Mark Z.
---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss

---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss