RE: looking for db recommendation

If you like right click solutions for importing then you can also check out
Aqua Fold Data Studios. It has a limited trial but it makes things easy as
you can connect up to your MS Access db and export the entire database
(table creation, caned queries, and data) with just a few clicks.
Recreating in MySQL becomes just as easy. If you can have both MySQL on
SuSE running and MS Access on win xp, then I would, personally, use access
to to directly transfer the data. It's easy and you can immediately verify
everything is how you want it so their are no surprises. Otherwise you can
export each table as a cvs file and import them using one of the MySQL admin
apps (or command line) or you can use AFDS to do everything for you. No
matter what you choice to do I would still back up the tables as CVS files
and toss them on a jump drive, just in case.

_____

From: plug-discuss-bounces@lists.plug.phoenix.az.us
[mailto:plug-discuss-bounces@lists.plug.phoenix.az.us] On Behalf Of keith
smith
Sent: Tuesday, March 31, 2009 12:31 PM
To: Main PLUG discussion list
Subject: Re: looking for db recommendation



If you install and use PhpMyAdmin you can easily import a CSV I assume you
can export from access in that format.

I searched on "import CSV into mysql" and found a few sites that looked
helpful. You would be doing so on the command line if you follow these
tutorials.

Search this page for CSV
http://dev.mysql.com/doc/refman/5.1/en/load-data.html and you will see the
following.

LOAD DATA INFILE can be used to read files obtained from external sources.
For example, many programs can export data in comma-separated values (CSV)
format, such that lines have fields separated by commas and enclosed within
double quotes. If lines in such a file are terminated by newlines, the
statement shown here illustrates the field- and line-handling options you
would use to load the file:

LOAD DATA INFILE 'data.txt' INTO TABLE tbl_name
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n';

---
I hope this helps.


------------------------
Keith Smith



--- On Tue, 3/31/09, Jerry Davis <jdawgaz@cox.net> wrote:




From: Jerry Davis <jdawgaz@cox.net>
Subject: Re: looking for db recommendation
To: plug-discuss@lists.plug.phoenix.az.us
Date: Tuesday, March 31, 2009, 12:02 PM


On Tue, 31 Mar 2009 10:29:21 -0700
Mike Schwartz <mike.l.schwartz@gmail.com> wrote:

> 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 ...

postgresql or mysql would be my choice.
i'm sure both have an import.
if not, a very short perl dbi script would do it nicely.

--
Happy Trails!
Jerry (K7AZJ)
Hobbit Name: Pimpernel Loamsdown
Registered Linux User: 275424
This email's random fortune:
Be free and open and breezy! Enjoy! Things won't get any better so
get used to it.
---------------------------------------------------
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