从Oracle 10g迁移到Db2 8.2 [英] Moigration from Oracle 10g to Db2 8.2
问题描述
我想将Oracle 10g数据库迁移到Db2。我想要一些
文档来比较这些与数据库之间的比较。我也想要知道不支持Db2和
支持哪些Oracle 10g功能。
I want to migrate my Oracle 10g database to Db2. I want some
documentation for the comparision between these to databases. I also
want to know which features of Oracle 10g are supported by Db2 and
which are not supported.
推荐答案
" Ashish Patankar <关于************ @ gmail.com>在消息中写道
news：11 ********************** @ j55g2000cwa.googlegr oups.com ...
"Ashish Patankar" <as************@gmail.com> wrote in message
news:11**********************@j55g2000cwa.googlegr oups.com...
我想将Oracle 10g数据库迁移到Db2。我想要一些
文档来比较这些与数据库之间的比较。我还想知道Db2和
支持哪些Oracle 10g的功能不受支持。
I want to migrate my Oracle 10g database to Db2. I want some
documentation for the comparision between these to databases. I also
want to know which features of Oracle 10g are supported by Db2 and
which are not supported.
IBM提供迁移工具包以下网站：
http：// www- 306.ibm.com/software/data/db2/migration/
DB2非常接近ANSI SQL，但Oracle引入了许多专有的
SQL扩展，所以它取决于你的应用程序中使用了多少个专有扩展
它的难度。几乎所有问题都有解决方法，如果你在工具包中找不到它，那么你可以在这个论坛中询问这个问题（但请查看Google网上论坛存档）首先）。
IBM offers migration toolkits at the following site:
http://www-306.ibm.com/software/data/db2/migration/
DB2 is fairly close to ANSI SQL, but Oracle has introduced many proprietary
SQL extensions, so it depends on how many proprietary extensions where used
in your apps as to how difficult it will be. There are work-arounds for
almost all issues, and if you cannot find it documented in the toolkit, you
can ask here in this forum (but check Google Groups archives first).
Ashish Patankar <关于************ @ gmail.com> $écritdansle message de
news： 11 ********************** @ j55g2000cwa.googlegroups。 com ...
我想将Oracle 10g数据库迁移到Db2。我想要一些
文档来比较这些与数据库之间的比较。我也想知道Db2和
支持哪些Oracle 10g的功能不受支持。
I want to migrate my Oracle 10g database to Db2. I want some
documentation for the comparision between these to databases. I also
want to know which features of Oracle 10g are supported by Db2 and
which are not supported.
最大的痛苦将是严格的数据类型处理，日期/时间差异，
和错误处理。
在迁移过程中，约束也会造成一些困难。
The biggest pain will be strict datatype handling, date / time differences,
and error handling.
During migration constraints will also cause some difficulties.
" Ashish Patankar" <关于************ @ gmail.com>在消息中写道
news：11 ********************** @ j55g2000cwa.googlegr oups.com ...
"Ashish Patankar" <as************@gmail.com> wrote in message
news:11**********************@j55g2000cwa.googlegr oups.com...
我想将Oracle 10g数据库迁移到Db2。我想要一些
文档来比较这些与数据库之间的比较。我还想知道Db2和
支持哪些Oracle 10g的功能不受支持。
I want to migrate my Oracle 10g database to Db2. I want some
documentation for the comparision between these to databases. I also
want to know which features of Oracle 10g are supported by Db2 and
which are not supported.
Dude，Oracle 8i到DB2 8.2是迁移。 Oracle 10g到DB2 8.2是降级和迁移的
。根据使用的10g功能，您可以在$ DB2中找到更多或更少的不支持或不同的东西。
Dude, Oracle 8i to DB2 8.2 is a migration. Oracle 10g to DB2 8.2 is a
downgrade and migration. Depending on what 10g features are used, you may
find more or fewer things not supported or different in DB2.
这篇关于从Oracle 10g迁移到Db2 8.2的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
