ACUVA

Your Accurate Search for New Technology

Amazon RDS for Oracle Now Supports In-region Read Replicas with Active Data Guard for Read Scalability and Availability

By

Starting today, Amazon Relational Database Service (RDS) for Oracle supports Read Replicas with Active Data Guard. Amazon RDS for Oracle makes it easy to create the replicas in the same AWS Region as the primary DB instance by fully managing the configuration of Active Data Guard, and maintaining secure network connections between a primary DB instance and its replicas.

The Read Replicas feature is supported for RDS Oracle customers who are using the Bring Your Own License model with Oracle Database Enterprise Edition and have licensed the Active Data Guard Option. This feature allows RDS Oracle customers to offload their read workload from the primary DB Instance, and also supports the scalability of read workloads over a farm of up to five read replicas. The Read Replicas can also render another level of availability by allowing you to promote a given read replica as a new standalone database, in the event of a failure of the primary DB Instance.

A Read Replica is billed as a standard DB Instance and at the same rates. Just like a standard DB instance, the rate per “DB Instance hour” for a read replica is determined by the DB instance class of the read replica.

This feature is supported in all commercial regions where Amazon RDS for Oracle is available, except in the Stockholm and Ningxia regions. To learn more, please visit the In-region Oracle Read Replicas documentation page.

Amazon RDS makes it easy to set up, operate, and scale a relational database in the cloud. See Amazon RDS for Oracle Pricing for up-to-date pricing and regional availability.
 

AWS Schema Conversion Tool Adds New Conversion Features

By

The
AWS Schema Conversion Tool (AWS SCT) makes heterogeneous database migrations predictable by automatically converting the source database schema and a majority of the database code objects, including views, stored procedures, and functions, to a format compatible with the target database. With the latest version of AWS SCT (build 624), you can now take advantage of the following enhanced conversion features:
 
  1. Support for orafce extension when migrating from Oracle to PostgreSQL:  The orafce extension in PostgreSQL implements a subset of Oracle PL/SQL subprograms and packages in PostgreSQL, making the conversion of programmable database objects a straightforward task and migrations to PostgreSQL faster and easier. The orafce extension is supported in both Aurora PostgreSQL-compatible edition and RDS for PostgreSQL. More details about orafce can be found here .
  2. SAP ASE as a source support:  You can now convert database objects from an SAP Adaptive Server Enterprise (ASE) database—formerly known as Sybase—using AWS SCT to Amazon Aurora (PostgreSQL and MySQL-compatible editions), RDS for MySQL and RDS for PostgreSQL.
  3. RDS for MariaDB 10.2 & 10.3 as a target support:  You can now convert database objects from Oracle, Microsoft SQL Server and Db2 LUW to RDS for MariaDB versions 10.2 and 10.3 using AWS SCT. This gives you another option to migrate from commercial databases to an open source database in the cloud.
After converting your database schema and code objects using SCT, you can use  the
AWS Database Migration Service to migrate data from the source database to the target database to complete your migration projects.

AWS Schema Conversion Tool Adds Support for Migrating Oracle ETL Jobs to AWS Glue

By

Traditional extract, transform, and load (ETL) tools are complex to use, and can take months to implement, test, and deploy. After the ETL jobs are built, maintaining them can be time consuming because data formats and schemas change frequently and new data sources need to be added. Migrating ETL jobs to a fully managed, serverless ETL service like AWS Glue helps lower the operational overhead associated with managing complex ETL jobs. AWS Glue makes it easy to schedule recurring ETL jobs, chain multiple jobs together, or invoke jobs on-demand from other services like AWS Lambda. 

With the latest version of AWS Schema Conversion Tool (Build 624), you can now migrate Oracle ETL jobs to AWS Glue based ETL that will work with your Amazon Redshift data warehouse. You can automatically create an AWS Glue Data Catalog which is an index to the location, schema, and runtime metrics of your data. Once ETL migration is done, you can use SCT Data Extraction Agents to run data migrations from any of our supported data warehouse sources to Amazon Redshift and start modernizing your data stores.

For more details and information on SCT availability, visit our documentation .

Scroll Up