Informix 到 Microsoft SQL Server 2008、架构和数据迁移？
我正在查看一个使用旧版本 Informix 数据库（标准引擎 7 - 7.23C1）的应用程序。我正在研究将一些表和数据从 Informix 迁移到 Microsoft 的 SQL Server 2008 的方法。
是否有任何工具可以使这种迁移变得不那么痛苦？需要迁移的表有数百个，手动执行会花费很长时间。
I'm looking at an application that uses an old version of Informix database (standard engine 7 - 7.23C1). I'm investigating ways to migrate some tables and data from Informix to Microsoft's SQL Server 2008.
Are there any tools out there that can make this migration less painful? There are hundreds of tables that need to be migrated, doing it manually will take a very long time.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
“老”是多少岁？ Informix DBMS 是 OnLine 系列之一还是 SE（标准引擎）？粗略地说：哪个版本的 Informix DBMS 在哪个平台上运行？然而，答案实际上很大程度上独立于 DBMS 或版本（但如果您有一个足够旧的系统，它实际上可能很重要）。我假设 Informix 安装仍然可以运行；您仍然拥有可用的 Informix 软件。
从 Informix 数据库获取模式和数据的最佳工具是 dbschema。对于名为
somedb的数据库，这将创建一个目录somedb.exp，其中包含somedb.sql和一系列卸载文件。显然，该模式是为 Informix 设计的；您需要修改它以适合 SQL Server。数据采用 Informix 的标准卸载格式，该格式使用管道分隔字段，并以反斜杠作为转义字符。您必须设计一种方法将其转换为 SQL Server 的首选卸载格式。How old is 'old'? And is the Informix DBMS one of the OnLine family or is it SE (Standard Engine)? Roughly: which version of which Informix DBMS running on which platform? However, the answer is actually largely independent of DBMS or version (but if you have an old enough system, it might actually matter). I assume that the Informix installation is still operational; you still have the working Informix software.
The best tool to get the schema and data out of the Informix database is dbschema. For a database called
somedb, this will create a directorysomedb.expcontainingsomedb.sqland a series of unload files. The schema is, obviously, designed for Informix; you will need to modify that to suit SQL Server. The data is in Informix's standard unload format, which uses pipe-separated fields with backslash as an escape character. You will have to devise a method of converting that to SQL Server's preferred unload format.