将Windows数据库中的未知数据库文件转换为MySqli数据库 [英] Convert an unknown database file from a windows software into a MySqli Database
问题描述
我已经在系统中安装了一个软件，并且其中有很多来自客户端的数据。该软件的DB文件夹中的所有文件都有各自单独的扩展名。
我想使用这些文件将其转换为MySqli数据库。 / p>
可以从这里
我尝试了解Firebird服务，该软件将Firebird服务用于与这些数据库文件连接以获取信息。
我想提取数据库并将其导入MySqli（PhpMyAdmin）
链接该文件似乎是重命名的Firebird数据库，其结构版本为ODS 11.2，对应于Firebird 2.5.x行。
为了快速浏览数据库，您可以使用
- IBSurgeon急救- http：/ /ib-aid.com
- IB专家（数据库资源管理器功能）- http://ibexpert.net
FirstAID的免费模式可以让您窥探数据，但不能将其提取出来，甚至可能无法滚动所有表。它也很可能会忽略所有不是表的数据库结构（UDF函数，过程，VIEW，表中的自动计算列）-毕竟，它只是低级格式解析器，而不是SQL引擎。
IB专家具有非商业性的个人版，但它可能不包括DB Exp，但是您可以尝试完整版的试用期。但是，IBE的DBExp也可能只显示数据库的基本结构，也许就足够了。
或者，您可以安装Firebird 2.5.8-独立版本或也许如果您的应用程序可以使用嵌入式的（使用一组DLL代替FB服务器进程），则可以使用任何DB IDE套件进行浏览。对于Firebird，最常提及的是IBExpert，FlameRobin，Firebird Maestro或其他任何工具。然后，如果数据库已注册并实际使用过，您将可以尝试其他SQL查询，包括SP，VIEW和UDF函数。
BTW IBExpert捆绑在一起FB 2.5 Embedded，可以用来打开数据库文件。
确定格式之后，可以将所需数据导出为CSV等中间格式（例如： http://fbutils.sourceforge.net/ ）或使用您的C ++应用程序（尽管为什么会这样任何人都可以使用IB ++或OLE DB等库来用C ++开发Web应用程序。也许最好只使用Firebird服务器和PHP的原始DB文件，或者用什么编写应用程序。
I have installed a software in my system and I have a lot of data from client in it. All the files which are inside DB folder of this software are with extensions for each individual party.
I want to to use these files to get converted to a MySqli Database.
Sample file from DB folder can be download from here
I have tried understanding for firebird service which this software uses to connect with these database files to get the things.
I want to extract database and import it inside MySqli (PhpMyAdmin)
The linked file seems to be a renamed Firebird database with structure version ODS 11.2 which corresponds to Firebird 2.5.x line.
For making a quick peep into the database you can use
- IBSurgeon First Aid -- http://ib-aid.com
- IB Expert (the Database Explorer feature) -- http://ibexpert.net
Free mode of FirstAID would let you peep into the data, but not extract it out, probably not even scroll ALL the tables. It also would most probably ignore all database structures that are not tables (UDF functions, procedures, VIEWs, auto-computed columns in tables) - afterall it is just low-level format parser, not an SQL engine.
IB Expert has as a non-commercial Personal edition, but it probably does not include DB Exp, however you may try a trial period of full version. However IBE's DBExp would probably also only show basic structures of the database, maybe it would be enough.
Alternatively you can install Firebird 2.5.8 - either a standalone version or maybe embedded (a set of DLLs used instead of FB server process) if your application can use it, then use any DB IDE suit to explore it. Most often mentioned for Firebird would be IBExpert, FlameRobin, Firebird Maestro or any other. Then you would be able to try different SQL queries, including SPs, VIEWs and UDF-functions if there were any registered for the database and actually used.
BTW IBExpert comes bundled with FB 2.5 Embedded, which one can use to open the database file.
After you figure out the format, you can either export required data into some intermediate format like CSV (for example: http://fbutils.sourceforge.net/ ) or use your C++ application (though why would anyone develop web-application in C++) using libraries like IB++ or OLE DB, etc. Maybe it would be better to just use the Firebird server and original DB files from PHP or what would you write the application in.
这篇关于将Windows数据库中的未知数据库文件转换为MySqli数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
