Subject | Re: [firebird-support] Exporting data from firebird |
---|---|
Author | Milan Babuskov |
Post date | 2010-11-12T11:26:06Z |
Philip wrote:
be exported as SQL statements:
http://www.firebirdfaq.org/fbexport.php
However, it might be more efficient to use DB Workbench or similar
Windows tool to copy the data directly (if you have fast connection to
both servers). There are slight differences between Firebird and MySQL,
so if you want to keep it Linux-only, you might need to do a
find&replace (via "sed" for example) on FBExport dump file before
importing it into MySQL. It all depends on the data types used for table
columns.
HTH
--
Milan Babuskov
==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================
> Is there a way to dump the data from Firebird as SQL statements, as per the mysqldump utility?You can use FBExport tool for that. Everything except binary BLOBs can
be exported as SQL statements:
http://www.firebirdfaq.org/fbexport.php
However, it might be more efficient to use DB Workbench or similar
Windows tool to copy the data directly (if you have fast connection to
both servers). There are slight differences between Firebird and MySQL,
so if you want to keep it Linux-only, you might need to do a
find&replace (via "sed" for example) on FBExport dump file before
importing it into MySQL. It all depends on the data types used for table
columns.
HTH
--
Milan Babuskov
==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================