将 IBXpress Interbase 6 应用程序移植到 Delphi 7 上当前的 Firebird 平台?

发布于 2024-08-10 12:20:42 字数 589 浏览 5 评论 0原文

只是想知道这里是否有任何需要警惕的问题。我们有一个几年前为客户开发的遗留 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 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(2

温折酒 2024-08-17 12:20:42

如果您不使用 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

简单爱 2024-08-17 12:20:42

除了数据库访问组件之外,您还需要一些工具来轻松将现有 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

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文