On Thu, 31 Jul 2014, Graeme Geldenhuys wrote:
On 2014-07-31 17:48, Michael Van Canneyt wrote:
I created a FPC program to migrate a mantis bugtracker database from MySQL to
Postgres.
And soon there will be one from MySQL to Firebird too. :-) Seems great
minds think alike. My tiDataPump tool (yes, tiOPF based) already
managed to convert a 80GB PostgreSQL database to Firebird. MySQL was my
next target.
I would be interested in your code though, so I can improve the MySQL
and PostgreSQL mapping in tiOPF. So if you could sent that email, it
would be much appreciated.
See SVN :)
But the code is pretty simple, nothing special.
It just takes some care of bugs I encountered in the MySQL database, and it converts
int to boolean through some casting tricks in SQL.
(It seems Mantis creates different databases for different engines)
The hard work is creating all the SQL statements.
Michael.
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
