Moving Your Oracle Database To The Cloud - Part 2

Moving databases to the cloud and making the transition to Database as a Service (DBaaS) can be like having one foot on the boat and the other on the dock.

Cloud migration of databases should not affect the applications running on those databases before, during or after migration. Users should be able to execute tasks like reporting, querying and analysis throughout the migration process. Database administrators (DBAs) should be able to roll back a production database in the event of a problem during migration, with no impact on user activity.

As described in part 1 of this series, you have four options when moving to a cloud-based database:

   • Start with tables and schemas that support applications that are not critical to the business.

   • Develop brand-new applications using databases in the cloud, without migrating old databases at all.

   • Take the big-bang approach by backing up and restoring before users are affected.

   • Use data replication from a source database on premises to a target database in the cloud.

This final part in the series examines the use of SharePlex® data replication technology in moving Oracle® databases to the cloud. SharePlex tracks and preserves database updates to keep your source and target instances synchronized. DBAs and system administrators will take away an understanding of how to implement SharePlex in their own Oracle migration projects.