cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

PWH Migration from MS SQL to Oracle

Babar_Qayyum
Leader

Dear All,

We are planning to migrate the PWH from MS SQL to Oracle. Did anyone already tried this scenario? What could be the expected challenges?

Regards,

Babar


1 REPLY 1

peter_karlhuber
Dynatrace Pro
Dynatrace Pro

Hi Babar,

it's very difficult to migrate a schema from one dbms to another. We had more success using the system profile data importer task that's been added in version 6.5.

With it, you can selectively start data migration tasks for specific system profiles moving the data from a source database to the target one, regardless of vendor.

It's documented here

Please let us know if you need more details, cheers,

Peter