RedGate makes a tool for Microsoft SQL Server that allows you to snapshot the difference between two databases. It generates the scripts needed to update the database schema while preserving the data.
RedGate为Microsoft SQL Server提供了一个工具，允许您对两个数据库之间的差异进行快照。它生成更新数据库模式所需的脚本，同时保留数据。
I need to find a tool like this for the Firebird database. We use Firebird in an embedded fashion, and would like to push out schema updates to remote machines with as little hassle as possible.
我需要为Firebird数据库找到这样的工具。我们以嵌入式方式使用Firebird，并且希望尽可能少地将模式更新推送到远程计算机。
7 个解决方案
#1
1
I don't know of a tool for Firebird that does exactly the same.
我不知道Firebird的工具完全相同。
However, FlameRobin allows you to extract the metadata for single database objects or the complete database. It can also create scripts to recreate a certain database object including its dependencies. So you could either diff two database creation scripts and save the differences as the starting point (which may still need some changes), or you could use the recreation scripts for a single object and its dependencies.
但是，FlameRobin允许您提取单个数据库对象或完整数据库的元数据。它还可以创建脚本来重新创建某个数据库对象，包括其依赖项。因此，您可以区分两个数据库创建脚本并将差异保存为起点（可能仍需要进行一些更改），或者您可以将重新创建脚本用于单个对象及其依赖项。
#3
1
As @devio suggsted, I took a look at the large list of administration tools listed on the IBPhoenix site. Of the tools on the list, the only two that generate scripts to migrate schema and data changes are XCase and Database Workbench.
正如@devio所说，我看了一下IBPhoenix网站上列出的大量管理工具。在列表中的工具中，只有两个生成用于迁移模式和数据更改的脚本的是XCase和Database Workbench。
Does anyone have experience with these tools? Are there others that I may have missed?
有没有人有这些工具的经验？还有其他我可能错过的吗？
#4
1
Embarcadero Change Manager will add support for InterBase and Firebird in the fall. Read all about it here. Change Manager includes schema archive compare and synchronizations, data compare, sync, and masking, and configuration management.
Embarcadero Change Manager将在秋季增加对InterBase和Firebird的支持。在这里阅读所有相关信息。变更管理器包括模式存档比较和同步，数据比较，同步和屏蔽以及配置管理。
#5
1
see IBExpert, it have a command line tool too where you can run scripts in a propietary language. You can compare two db and get the script to update the target db, it does a great job with dependecies, like views, it drops every dependency where the view is used, alter the view and then recreate the dropped objects. This can be done in GUI too, and a lot of other nice things
看到IBExpert，它也有一个命令行工具，你可以用专用语言运行脚本。您可以比较两个db并获取脚本以更新目标数据库，它可以很好地处理依赖性，例如视图，它会删除使用视图的每个依赖项，更改视图，然后重新创建已删除的对象。这也可以在GUI中完成，还有许多其他好东西
#6
1
Migration tools for Firebird on IBPhoenix site are on a separate link Contributed Downloads - Migration Tools
IBPhoenix站点上Firebird的迁移工具位于单独的链接上。供稿下载 - 迁移工具
#7
0
Try SchemaCrawler link
尝试SchemaCrawler链接
SchemaCrawler is an open-source Java API that makes working with database metadata as easy as working with plain old Java objects.
SchemaCrawler是一个开源Java API，它使得处理数据库元数据就像使用普通的旧Java对象一样简单。
SchemaCrawler is also a command-line tool to output your database schema and data in a readable form. The output is designed to be diff-ed with previous versions of your database schema.
SchemaCrawler也是一个命令行工具，用于以可读的形式输出数据库模式和数据。输出旨在与先前版本的数据库模式区分开来。
As it requires a JDBC driver, you would also need the following: Firebird JDBC Driver
由于它需要JDBC驱动程序，因此您还需要以下内容：Firebird JDBC Driver
#1
1
I don't know of a tool for Firebird that does exactly the same.
我不知道Firebird的工具完全相同。
However, FlameRobin allows you to extract the metadata for single database objects or the complete database. It can also create scripts to recreate a certain database object including its dependencies. So you could either diff two database creation scripts and save the differences as the starting point (which may still need some changes), or you could use the recreation scripts for a single object and its dependencies.
但是，FlameRobin允许您提取单个数据库对象或完整数据库的元数据。它还可以创建脚本来重新创建某个数据库对象，包括其依赖项。因此，您可以区分两个数据库创建脚本并将差异保存为起点（可能仍需要进行一些更改），或者您可以将重新创建脚本用于单个对象及其依赖项。
#2
#3
1
As @devio suggsted, I took a look at the large list of administration tools listed on the IBPhoenix site. Of the tools on the list, the only two that generate scripts to migrate schema and data changes are XCase and Database Workbench.
正如@devio所说，我看了一下IBPhoenix网站上列出的大量管理工具。在列表中的工具中，只有两个生成用于迁移模式和数据更改的脚本的是XCase和Database Workbench。
Does anyone have experience with these tools? Are there others that I may have missed?
有没有人有这些工具的经验？还有其他我可能错过的吗？
#4
1
Embarcadero Change Manager will add support for InterBase and Firebird in the fall. Read all about it here. Change Manager includes schema archive compare and synchronizations, data compare, sync, and masking, and configuration management.
Embarcadero Change Manager将在秋季增加对InterBase和Firebird的支持。在这里阅读所有相关信息。变更管理器包括模式存档比较和同步，数据比较，同步和屏蔽以及配置管理。
#5
1
see IBExpert, it have a command line tool too where you can run scripts in a propietary language. You can compare two db and get the script to update the target db, it does a great job with dependecies, like views, it drops every dependency where the view is used, alter the view and then recreate the dropped objects. This can be done in GUI too, and a lot of other nice things
看到IBExpert，它也有一个命令行工具，你可以用专用语言运行脚本。您可以比较两个db并获取脚本以更新目标数据库，它可以很好地处理依赖性，例如视图，它会删除使用视图的每个依赖项，更改视图，然后重新创建已删除的对象。这也可以在GUI中完成，还有许多其他好东西
#6
1
Migration tools for Firebird on IBPhoenix site are on a separate link Contributed Downloads - Migration Tools
IBPhoenix站点上Firebird的迁移工具位于单独的链接上。供稿下载 - 迁移工具
#7
0
Try SchemaCrawler link
尝试SchemaCrawler链接
SchemaCrawler is an open-source Java API that makes working with database metadata as easy as working with plain old Java objects.
SchemaCrawler是一个开源Java API，它使得处理数据库元数据就像使用普通的旧Java对象一样简单。
SchemaCrawler is also a command-line tool to output your database schema and data in a readable form. The output is designed to be diff-ed with previous versions of your database schema.
SchemaCrawler也是一个命令行工具，用于以可读的形式输出数据库模式和数据。输出旨在与先前版本的数据库模式区分开来。
As it requires a JDBC driver, you would also need the following: Firebird JDBC Driver
由于它需要JDBC驱动程序，因此您还需要以下内容：Firebird JDBC Driver