Firebird News

Tuesday, September 21, 2010

Howto and tips :converting from #mysql to #firebirdsql

here are some basic types to be converted from mysql to firebirdsql when you run the create table scripts

  • int(10)->int
  • smallint(5)->int
  • datetime->timestamp
  • replace the ` with double quote " or with nothing

dump the database with full inserts and then run it with flamerobin
mysqldump  -u root --password=mysql_password -t -c dbname tablename > /tmp/foo.sql

another option is to put dump table in csv format and import it using a php script
that fetches each row and inserts it into firebird table
here is one example for a table with 3 columns

or search for a tool that will do that for you

No comments: