QuestionQ46

VerifiedAccelerate Workload Migration and Modernization

A company needs to move some on-premises Oracle databases to AWS. The company has chosen to keep some of the databases on premises for business compliance reasons.

The on-premises databases contain spatial data and run cron jobs for maintenance. The company needs to connect to the on-premises systems directly from AWS to query data as a foreign table.

Which solution will meet these requirements?

Explanation

Amazon RDS for PostgreSQL natively supports spatial data through the PostGIS extension, making it suitable for Oracle spatial data. AWS Schema Conversion Tool and DMS enable schema migration with full support for stored procedures. AWS Direct Connect provides the secure, low-latency connectivity needed for foreign table queries to on-premises Oracle databases, while PostgreSQL's pg_cron extension supports scheduled maintenance jobs.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!