On Tue, Mar 31, 2009 at 9:57 AM, mz <
mz@infomagic.net> wrote:
> 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
> how best to accomplish the migration?
Even M$ Access can output ("export"?)
data in the format of a CSV file, right?
(comma separated values)
That should be all you need, to "import"
to your destination db -- MySql or whatever.
And (IANA Db admin, but) I think any good db
should be able to "import" a CSV file (right?)
...if not, then you might want to get a
"second opinion", on the
> recommendations for a db
just my 0.02 ...
--
Mike Schwartz
Glendale AZ
schwartz@acm.org
---------------------------------------------------
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
(text/plain)