Migration options - AWS Prescriptive Guidance

Migration options

The following decision tree diagram presents the options as different migration paths based on the platform family, outage requirements, and configuration. These paths can help you understand different options.

  • Little endian compared with big endian

  • A short outage window (less than 15 minutes, with time unrelated to database size) compared with a long outage window (more than 15 minutes, with time related to the database size)

  • Data Partitioning Feature (DPF) has been used or not

Information show in the diagram is repeated in the tables.

The following tables show high-level comparisons of the migration options based on the source platform.

Little-endian platform

Backup and restore

HADR failover

Backup and restore with log shipping

Outage

Long (related to DB size)

Short

Short

Complexity

Low

Medium

Medium

Extra license

No

No

No

DB size limit

Small to medium size

Any size

Any size

Schema migration required

No

No

No

Supports non-logged transaction

Yes

No

No

DPF support

Yes

No

Yes

Fallback capability

Manual setup

Automatic

Manual setup

Logical replication

Q Replication

SQL Replication

InfoSphere CDC

Outage

Short

Short

Short

Complexity

High

High

High

Extra license

Yes

No

Yes

DB size limit

Any size

Any size

Any size

Schema migration required

Yes

Yes

Yes

Performance impact on source database

Low

High

Medium

Replication performance for heavy write traffic

Good

Bad

Varies

Supports non-logged transaction

No

No

No

DPF support

Yes

Yes

Yes

Fallback capability

Reverse replication

Reverse replication

Reverse replication

Big-endian platform

In the following table, logical replication includes Q Replication, SQL Replication, InfoSphere CDC, and third-party replication tools.

 

Logical replication

Unload and load

Optim High Performance Unload

LOAD FROM CURSOR

db2move

Outage

Short

Medium

Varies

Varies

Complexity

High

Medium

Medium

Low

Extra license

Depends (See the Logical replication table.)

Yes

No

No

DB size limit

Any size

Medium

Small

Small

Schema migration required

Yes

Yes

Yes

Yes

Supports non-logged transaction

No

Yes

Yes

Yes

DPF support

Yes

Yes

Yes

Yes

Fallback capability

Reverse replication

Extract and load new data

Extract and load new data

Extract and load new data