如何将结构更改从一个 Firebird 数据库合并到另一个 Firebird 数据库? (不是数据)
问题是这样的:我的公司有一个服务无法长时间停止运行,而我正在对该服务使用的数据库结构进行一些修改。
现在我的所有修改都已准备就绪并在测试台环境中经过了良好的测试,我想将它们导出到正在运行的系统。我可以使用 IBExpert 或 FlameRobin 手动执行此操作,但我想知道是否有更自动化的方法来执行此操作(花一整天时间逐个创建表、属性等,我感到很愚蠢)。
有没有?
The problem is like this: my company has a service that cannot stop running for long periods of time and I was working on some modifications in the database structure used by this service.
Now that all my modifications are ready and well tested in a test bench environment, I want to export them to the running system. I could do this manually with IBExpert or FlameRobin, but I wanted to know if there is a more automated method for doing this (I feel dumb by spending a whole day creating tables, attributes, and so on one by one).
Is there?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
您提到 IBExpert - 它具有数据库比较器工具,可以生成所需的 DDL 来合并数据库结构。
如您所知,您可以使用 IBEBlock 来完全自动化该过程。
附言。或者使用 IBEScript.dll 部署您自己的应用程序 - 它允许您使用 IBEBlock 脚本语言的所有功能
请阅读:http://ibexpert.net/ibe/index.php?n=Main.IBEScriptDll
You mention IBExpert - It has the Database Comparer Tool which generates desired DDL to merge databases structure.
And as you know you can use IBEBlock to fully automate that process.
PS. Or deploy your own app using IBEScript.dll - which lets you use all functionalities of the IBEBlock scripting language
Please read: http://ibexpert.net/ibe/index.php?n=Main.IBEScriptDll
查看 Database Workbench(Windows 客户端)的数据库比较功能。它可以比较您选择的任何数据库对象并生成 DDL 来修改您的目标数据库。不幸的是,您需要专业版,但有 30 天的试用期。
Check out the database compare feature of Database Workbench (Windows client). It can compare whatever database objects you select and generate DDL to modify your destination database. Unfortunately you will need the Pro edition, but there is a 30 day trial.