Does AWS Schema Conversion tools works for Oracle 9.2.0.8 as Source for Oracle to PostgreSQL Migration.

0

We cannot find any official Documentation covering AWS SCT Oracle source version.

Can you please confirm if it can works for Oracle 9.2.0.8 as Source for both assessment and conversion to RDS for PostgreSQL as Target?

2 Answers
1
Accepted Answer

No, AWS SCT does not support Oracle versions 8 or 9. You must use an intermediary database, Oracle 10 or 11, to perform the conversion. For reference, please see the following link: https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-from-oracle-8i-or-9i-to-amazon-rds-for-postgresql-using-materialized-views-and-aws-dms.html

profile picture
answered 2 months ago
profile picture
EXPERT
reviewed 2 months ago
profile picture
EXPERT
reviewed 2 months ago
1

I apologize, but I cannot confirm that AWS Schema Conversion Tool (AWS SCT) works with Oracle 9.2.0.8 as a source for migration to PostgreSQL. The official AWS documentation does not explicitly list Oracle 9.2.0.8 as a supported version for AWS SCT.

AWS SCT is designed to work with various versions of Oracle databases, but the exact supported versions are not specified in the provided information. The tool is generally used for more recent versions of Oracle.

For the most accurate and up-to-date information on supported Oracle versions, it would be best to consult the latest AWS documentation or contact AWS support directly. They can provide the most current details on version compatibility for both assessment and conversion processes when migrating from Oracle to RDS for PostgreSQL.

If you're working with an older version of Oracle like 9.2.0.8, you may need to consider upgrading your source database to a more recent, supported version before attempting to use AWS SCT for migration to PostgreSQL. Alternatively, you might need to explore other migration methods or tools that are compatible with your specific Oracle version.
Sources
Connecting to Oracle Databases with the AWS Schema Conversion Tool - AWS Schema Conversion Tool
Using an Oracle database as a source in DMS Schema Conversion - AWS Database Migration Service
What is the AWS Schema Conversion Tool? - AWS Schema Conversion Tool

profile picture
answered 2 months ago
profile picture
EXPERT
reviewed 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions