Tuesday, February 14, 2006

Porting the EMPLOYEE database from Firebird 2.0 to MySQL 5.1

Pabloj ( Moderator of Oracle and MsSQL (a.k.a. SQLServer) forums at Devshed.com) wrote an article comparing firebird and mysql 5.1.x features And he used flamerobin in the process ;) :
"Hi, I've decided to make an in depth test of MySQL's new functionalities by porting Firebird's EMPLOYEE.FDB database to MySQL 5.1.5, here is what I found, I hope it will be useful for people porting apps from MySQL to Firebird and vice-versa.
First of all, a screenshot (taken from Firebird's excellent Flamerobin admin tool) showing the actual employee.fdb structure.
Note the presence of generators, (aka sequences) won't be available in MySQL, I'll mimic them with autoincrement fields."
..:: ::..:: ::..

No comments: