[Calendula-devel] data migration

[Thomas Panzarella]

I'm not familiar with FileMaker (and only vaguely familiar with Access),
but on the Access front you could use a product like
http://www.mysql.com/portal/software/item-98.html to convert the Access
DB to MySQL and then from MySQL you can pretty much take it anywhere (or
leave it there since MySQL is mature and robust -- IMHO).

Also, I know Access can be used as an ODBC data source (maybe file maker
can too???) -- so why not "roll your own" export utility? -- for example
in Java you could use the freely supplied JDBC/ODBC bridge and pull data
from access to whatever you want using standard JDBC.  Does Python have
some type of bridging driver to ODBC?  Since it seems Python is your
lang of choice, I'd check that out.

t.


> -----Original Message-----
> From: Creede Lambard [mailto:creede@penguinsinthenight.com]
> Sent: Thursday, March 11, 2004 6:48 PM
> To: Darryl Caldwell
> Cc: caldev
> Subject: Re: [Calendula-devel] data migration
>=20
>=20
> I don't have experience, but I do have Google.
>=20
> http://starship.python.net/crew/bwilk/access.html
>=20
> This page admits to being somewhat outdated but might give=20
> some pointers as
> to how to read an Access database from Python. Unfortunately=20
> you apparently
> have to do this on a machine with a Jet DB engine running, which means
> Windows; fortunately it looks like SQL is available in the=20
> queries (at least
> the example given contains a SQL query).
>=20
> Ideally there would be a native Python module that would read=20
> Access and
> FileMaker tables (maybe even entire databases) and spit them=20
> back out in CSV
> or some other easily exportable format.
>=20
> On Thu, Mar 11, 2004 at 03:34:39PM -0800, Darryl Caldwell wrote:
> > Does anyone on the list have experience with migrating data from
> > FileMaker and/or MS Access?
> >=20
> > I am looking ahead to import/export issues.
> >=20
> > And are there any more comments on the diagram?
> >=20
> > -D
> >=20
> > --=20
> > Darryl Caldwell darrylc@fudosys.com
> > Fudo Systems  www.fudosys.com
> > 206/567-5802  "Free Your Computers!"
> >=20
> > _______________________________________________
> > Calendula-devel mailing list
> > Calendula-devel@fudosys.com
> > http://list.fudosys.com/mailman/listinfo/calendula-devel
>=20
> --=20
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>                                * .~. (   : Creede Lambard         :
>  Never rush a miracle man.    . / V \  . :------------------------:
>  You get lousy miracles.       /(   )\   : creede at              :
> --------------------------------^^-^^----:     penguinsinthenight :=20=20
>  Linux. Reliable and free. Pick any two. :         dot com        :
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>=20