[fpc-pascal] Migrate mantis bugtracker
Michael Van Canneyt
michael at freepascal.org
Fri Aug 1 09:47:06 CEST 2014
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.
More information about the fpc-pascal