I used Pentaho Kettle (ETL tool) to transfer data from MySQL to
Firebird. If I am not mistaken, the most hard part was to handle the
case-sensitive column names in MySQL database.

Roman


Gesendet mit AquaMail für Android
http://www.aqua-mail.com

Am 31. Mai 2012 13:09:20 schrieb "Umberto" <masotti@...>:

> I'm trying to test Pentaho on Firebird running on my Ubuntu
> workstation, following this blog:
> http://interestingittips.wordpress.com/2011/04/27/complete-pentaho-installation-on-ubuntu-part-1/
> In the second part you create a set of permanent schemas, instead of
> ram based original Pentaho's sample.
> I've already created hibernate, quartz and steelwheels example schemas,
> they are the simplest part, but foodmart (the Mondrian sample db) is
> huge to reformat from MySql.
>
> I've almost done in DDL scripting, but to convert all INSERT from MySql
> dump format IMHO the only viable solutions are:
> - writing a PHP script to populate database.
> - asking an existent backup.
>
> Are there someone that has a populated firebird foodmart database in
> trasportable backup format?
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>