将Firebird数据库导出到sql [英] Export Firebird database to sql

问题描述

我在Firebird中有几个数据库，使用IBExpert作为GUI管理员.我将改用MySQL.我可以使用IBExpert备份数据库(这为我提供了完整的结构和数据)，但是phpMyAdmin无法读取gbak格式. PhpMyAdmin具有导出命令，可将活动数据库的数据和/或结构转储到sql文件中.可以使用IBExpert做类似的事情吗?

I have several databases in Firebird using IBExpert as the GUI admin. I am changing over to MySQL. I can use IBExpert to backup the database (which gives me the full structure and data) but the gbak format can't be read by phpMyAdmin. PhpMyAdmin has an export command that dumps the data and/or structure of the active database to an sql file. Is it possible to do something similar with IBExpert?

推荐答案

您可以使用 FBExport 工具生成带有插入内容的转储.但是，我不确定它是否仍可维护并能与最新的Firebird版本一起使用(它说它已针对Firebird 1.0-2.1进行了测试).

You can use the FBExport tool to generate a dump with inserts. However I am not sure if it is still maintained and works with the latest Firebird versions (it says it was tested against Firebird 1.0 - 2.1).

请参见将数据从Firebird导出到纯SQL插入/将数据从Firebird插入/导出到MySQL ，以获取有关如何使用此工具的示例:

See Export data from Firebird into pure SQL inserts/ export data from Firebird to MySQL for an example of how to use this tool:

$> FBExport.exe -D "c:\DB\WL.FDB" -U user –P password -Si -V TEST -F test.out

其中:
Si –表示导出到SQL插入"格式
V –要导出的表名
F –输出文件名

Where:
Si – means "export to SQL inserts" format
V – table name to export
F – output filename

这篇关于将Firebird数据库导出到sql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！