将 IBXpress Interbase 6 应用程序移植到 Delphi 7 上当前的 Firebird 平台?
只是想知道这里是否有任何需要警惕的问题。我们有一个几年前为客户开发的遗留 D7 应用程序,它使用 IBXpress 与开源 Interbase 6 版本进行对话。
这些天我们在该平台上遇到了许多问题(主要问题是在新硬件上连接/启动速度非常慢),并且客户同意花费一些时间/金钱将数据库转移到 Firebird。
我们真的不想开始将其移动到 D2010(或 D2007,这是我现在的偏好),因为我们认为我们可能必须将数据库层从 IBXpress 移动到其他最适合 Firebird 的东西。归根结底,客户只是希望减轻数据库的痛苦,而不是彻底检修/升级/重写应用程序。
考虑到 Firebird 的血统,从 IBXpress Interbase 6 到(无论如何)Firebird 是一条相当轻松、易于理解的路径吗?我们有相当多的存储过程、触发器(甚至数据类型)等现有的 IB 数据库已经存在(并且客户有许多付费客户都在使用该平台),因此我们认为迁移到 Firebird 可能比迁移到 SQL Express(或完全是另一种类型的 DB)更顺利。
请注意,我们并不是在寻求“嵌入式”数据库倡导 - 在我们的许多客户的客户安装中,该软件以多用户客户端-服务器方式使用,因此保持这种方法很重要。
Just wondering if there are any gotchas to be wary of here. We have a legacy D7 app that we developed several years ago for a client, which uses IBXpress to talk to the open source Interbase 6 build.
We're having a number of issues with that platform these days (very slow to connect/start-up on new hardware being the chief one) and the client has okayed spending some time/money moving the database over to Firebird.
We really DON'T want to embark upon moving it to D2010 (or D2007 which would be my preference right now) as we figure that we might have to move the database layer from IBXpress to something else to best suit Firebird anyway. And at the end of the day, the client is only looking to lessen the database pain, not overhaul/upgrade/rewrite the app.
Given the ancestry of Firebird, is it a fairly painless, well-understood path from IBXpress Interbase 6 to (whatever) with Firebird? We have quite a number of sprocs, triggers (and even datatypes) etc in the existing IB database already (and the client has a number of paying customers all using this platform) so we felt that going to Firebird was more likely to be a smoother move than moving to SQL Express (or another flavour of DB entirely).
Note that we're not looking for 'embedded' DB advocacy - in many of our client's customers' installations, the software is used in a multi-user client-server way so keeping that kind of approach is important.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
如果您不使用 unicode 字符集,IBExpress 仍然可以使用 Firebird 2.1。
您还可以切换到
- FIBPlus
- IBDac
- IBObjects
或 JVUIB 但是如果你使用很多数据集会更困难
IBExpress still work with Firebird 2.1 if you don't use unicode charset.
You can also switch to
- FIBPlus
- IBDac
- IBObjects
or JVUIB but it will be more hard if you use many dataset
除了数据库访问组件之外,您还需要一些工具来轻松将现有 IB 6.0 数据库迁移到 Firebird 2.5。我可以推荐 FDBConvert 实用程序,它可以节省大量时间。下载链接:
http://gsbelarus.com/gs/fdbconvert/fdbconvert_eng.html
Besides database access components you will also need in some tool for easy migration of your existing IB 6.0 databases to Firebird 2.5. I could recommend FDBConvert utility, which saves a great deal of time. Download link:
http://gsbelarus.com/gs/fdbconvert/fdbconvert_eng.html