Home icon

Migrate spatial columns from Oracle to Amazon Aurora PostgreSQL or Amazon RDS for PostgreSQL using AWS DMS

Database Blog

This AWS Database Blog article provides a comprehensive guide to migrating spatial columns from Oracle to Amazon Aurora PostgreSQL or Amazon RDS for PostgreSQL using AWS Database Migration Service (DMS).

  • Key migration steps include:
    • Setting up source Oracle and target PostgreSQL databases
    • Creating PostGIS extension in target database
    • Using AWS Schema Conversion Tool (SCT) to prepare table structures
    • Configuring AWS DMS endpoints and serverless migration task
  • Important considerations:
  • Spatial data (SDO_GEOMETRY) converts to PostgreSQL GEOMETRY type
  • Geometry columns must be nullable during migration
  • Requires PostGIS extension installation

The article provides detailed technical instructions for database administrators and developers looking to migrate spatial data between Oracle and PostgreSQL-compatible databases.

Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Oct 28
2025
Migrate Oracle reference partitioned tables to Amazon RDS or Aurora PostgreSQL with AWS DMS
Feb 26
2026
Replicate spatial data using AWS DMS and Amazon RDS for PostgreSQL
Jun 10
2026
How to migrate from Oracle to Amazon Aurora PostgreSQL using AWS CloudFormation (Part 1)
Jul 1
2024
AWS DMS homogenous migration from PostgreSQL to Amazon Aurora PostgreSQL

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.