自动化的Oracle模式迁移工具 [英] Automated Oracle Schema Migration Tool
问题描述
哪些工具(商业或OSS)提供基于GUI的机制来创建模式升级脚本?要明确的是，这里是工具职责:
What are some tools (commercial or OSS) that provide a GUI-based mechanism for creating schema upgrade scripts? To be clear, here are the tool responsibilities:
- 获得与最新架构版本(称为源")的连接.
- 获得与先前架构版本(称为目标")的连接.
- 比较源和目标之间的所有架构对象.
- 创建脚本以使目标架构与源架构等效(升级脚本").
- 创建一个回滚脚本以还原源架构，该脚本在升级脚本失败时(在任何时候)使用.
- 为架构对象创建单个文件.
该软件必须:
- 对重命名的列使用ALTER TABLE而不是DROP和CREATE.
- 使用Oracle 10g或更高版本.
- 创建可以批量执行(通过命令行)的脚本.
- 临时安装过程.
- (奖金)创建可以通过SQL * Plus执行的脚本.
以下是一些示例(来自StackOverflow，ServerFault和Google搜索):
Here are some examples (from StackOverflow, ServerFault, and Google searches):
- Change Manager
- Oracle SQL Developer
不符合标准或无法评估的软件包括:
Software that does not meet the criteria, or cannot be evaluated, includes:
- TOAD
- PL/SQL Developer -无效的SQL * Plus语句.不产生ALTER语句.
- SQL Fairy -无安装程序.复杂的安装过程.记录不足.
- DBDiff -数据集评估不完善，客户支持欠佳.
- OrbitDB -数据集评估失败.
- SchemaCrawler -没有易于识别的Oracle数据库下载版本.
- SQL比较-SQL Server，而不是Oracle.
- LiquiBase -需要更改开发过程.没有安装程序.手动编辑配置文件.无法识别自己的baseUrl参数.
- TOAD
- PL/SQL Developer - Invalid SQL*Plus statements. Does not produce ALTER statements.
- SQL Fairy - No installer. Complex installation process. Poorly documented.
- DBDiff - Crippled data set evaluation, poor customer support.
- OrbitDB - Crippled data set evaluation.
- SchemaCrawler - No easily identifiable download version for Oracle databases.
- SQL Compare - SQL Server, not Oracle.
- LiquiBase - Requires changing the development process. No installer. Manually edit config files. Does not recognize its own baseUrl parameter.
评估版唯一可以接受的残缺是时间.通过限制表和视图的数量来进行隐藏操作隐藏了可能的错误，这些错误仅在尝试迁移数百个表和视图的过程中才在软件中可见.
The only acceptable crippling of the evaluation version is by time. Crippling by restricting the number of tables and views hides possible bugs that are only visible in the software during the attempt to migrate hundreds of tables and views.
推荐答案
Schema Compare for Oracle 应该符合您的要求.可以在这里下载:
Schema Compare for Oracle should meet your requirements. This can be downloaded here:
http://www.red-gate.com/products/schema_compare_for_oracle /index.htm
这篇关于自动化的Oracle模式迁移工具的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
