将fbk(firebird)文件转换为MySql

问题描述：

我有firebird数据库文件，我想将其转换为Mysql，但是我不知道如何.您能帮我转换吗?还是可以给我参考，我必须使用什么软件来进行转换?

I have firebird database file and I want to convert it into Mysql, but I don't know how. Can you help me how to convert it? Or can you give me the reference what software I have to use to convert it?

谢谢

答

您必须使用 FBExport 工具生成带有插入内容的转储

You have to use FBExport tool to generate a dump with inserts

FBExport.exe -D "c:\DB\WL.FDB" -U user –P password -Si -V TEST -F test.out
Where: 
Si – means "export to SQL inserts" format
V – table name to export
F – output filename

请注意mysql中的日期.以正确的格式导出.要以自定义日期格式导出数据库，请使用:

Be careful with dates in mysql. Export in the correct format. To export db in custom date format use:

$> FBExport.exe -D "c:\DB\WL.FDB" -U user –P password -Si -V TEST -F     test.out -J "Y-M-D" -K "H:M:S"
Where: 
J  - date format
K – time format

要将日期导入到MySQL中，请使用SOURCE命令:

To import date to mySQL use SOURCE command:

$> mysql --user=root --password=password
$> use  database_name
$> SOURCE  c:\export\table_name.out

引用: http://kosiara87.blogspot.nl/2011/03/export-data-from-firebird-into-pure-sql.html

将fbk(firebird)文件转换为MySql

相关推荐