On Tue, 31 Mar 2009 10:29:21 -0700 Mike Schwartz wrote: > On Tue, Mar 31, 2009 at 9:57 AM, mz 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