cancel
Showing results for 
Search instead for 
Did you mean: 

DB migration Process

Former Member
0 Kudos

Hello Gurus,

My question is can we perform DB migration through the system copy option in swpm.We are trying to migrate from DB2 to MS SQL.

As per my knowledge source system export will be taken from DB2 under system copy and the import process will be done under the MS SQL as my target system is on MS SQL Database. Please help me if am not correct.

Regards...

Sanjay

Accepted Solutions (0)

Answers (2)

Answers (2)

Reagan
Advisor
Advisor
0 Kudos

You will need to do a Heterogeneous system copy (Migration) as you are changing the database.

You need to use the SWPM tool and select the "Migration )load based)" option.

The migration should be done by a certified OS DB migration consultant.

Former Member
0 Kudos

Hi Sanjay,

Yes you can perform DB migration using SWPM and you need to use R3load method.

Also you need to select below option.

Do refer the System copy guide based on your OS+DB combination.

Also Refer to TADM70 for getting insight of the migration process.

Regards,

Ram

Former Member
0 Kudos

Thanks for the quick response Ram,

So you say that the migration between DB2 to MS SQL is possible with SWPM?

(Heterogeneous DB restore/migration)

Plz clarify.

Regards,

Harish.

Former Member
0 Kudos

Hi Sanjay,

Yes its quite possible from DB2 to MS sql. But its a Heterogeneous system copy where your Database is changing. And this will follow under Heterogeneous Database migration. i hope your not changing your OS. If yes then its a OS/DB migration and you need to Refer to the Latest PAM sheet for the OS/DB support for the SAP product you want to migrate.

Regards,

Ram