admin 管理员组文章数量: 1184232
2024年3月20日发(作者：jquery移除事件的方法)
Migrating to Oracle Database
Your Guide to a Successful Migration, On-Premises or in the Cloud
ORACLE WHITE PAPER | FEBRUARY 2017
Introduction
This paper provides an in-depth look at the process of migrating third-party databases to Oracle Database 12c
using Oracle SQL Developer tools. It will help you determine what’s involved with converting a third-party database
to an Oracle Database instance, and also explain how to make your existing applications work with the finished
product – the migrated Oracle instance. You will learn how to create a migration repository, capture the source
database, convert it to the Oracle data type, and copy the data. The examples apply to on-premises and cloud
scenarios, with attention to two cloud environments: Oracle Database Cloud Service (DBaaS) and Oracle
Database Exadata Cloud Services.
Generally speaking, the process of migrating data from a third-party RDBMS to Oracle Database is
straightforward. Changing the architecture of your application so it can communicate with Oracle Database can be
as simple as dropping in a new JDBC or ODBC driver. Moving stored procedures to Oracle’s PL/SQL ecosystem is
slightly more complicated. Every migration is different, and some applications require changes at the lowest levels
of your technology stack. Asking the right questions up front is critical so you can identify potential roadblocks, and
plan accordingly.
This paper assumes you have access to Oracle Database 12.1.0.2 or higher. If you have questions regarding
Oracle Database licensing and pricing, please contact your Oracle account manager.
Benefits of Migrating to Oracle Database Cloud
Oracle Database 12c introduces several significant capabilities that significantly lower the cost and time required to
migrate non-Oracle databases to the Oracle platform. Oracle Database Cloud Service lets you choose pay-per-use
metered services, or a regular monthly subscription of Oracle 11g, 12.1 and 12.2 database services. You can
automatically provision high availability configurations to elevate service levels for maintenance or unexpected
failure scenarios. Provisioning choices include pre-packaged bundles of Oracle Database options for DevOps,
Performance, Security, Analytics and Monitoring. The service comes with an integrated Oracle Application Express
environment, allowing you move development activities to the cloud. Oracle Database 12c Multitenant makes it
easy to consolidate many databases quickly and manage them as a cloud service.
Identifying the Scope of Your Migration
Discussions regarding the migration to Oracle Database usually start with a series of questions:
What database are you migrating from? (For example, SQL Server or DB2)
o What version of this database?
If it’s the latest version, e.g. SQL Server 2016, are you using any version-specific
features?
How many databases are you migrating?
o If more than one, are they essentially copies of each other, or is each one a different migration?
How large are your databases (amount of disk space for the data itself in GB/TB)?
Do your database applications rely heavily on stored procedures?
o
o
How many stored procedures and triggers need to be migrated?
Do they predominately fall under the ‘select * from table return result set to application’
category?
What is your migration project timeline, and when do you need to “go Iive?”
1
MIGRATING TO ORACLE DATABASE
版权声明：本文标题：Oracle数据库迁移指南:从第三方数据库到Oracle Database 12c的迁移过程 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.roclinux.cn/b/1710927578a579945.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。
发表评论