Migrate PW from Postgresql to Oracle

Question

Question by Flora H. · Jul 25, 2013 at 09:43 PM ·

Migrate PW from Postgresql to Oracle

Hi,

One of my customer is using Postgresql for their performance warehouse, and considering moving Oracle later on, is there any script we can utilize for the migration effort?

Note that it's dynaTrace 5.5 Prod Edition.

Thanks,

Flora

0

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Answer 1 · 2013-07-26T10:32:39Z

Answer by Stefan G. · Jul 26, 2013 at 10:32 AM

Hi, there is no built in functionality nor do we provide scripts for that as there is a whole bunch of 3rd party solutions (including a lot of freebies) available which enable migration from postgre to oracle data.

Nevertheless we did that once for a customer but be aware that this involves moving a lot of data later on so this will result often in a significant downtime of the pwh at the customer.

stefan

0 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Answer 2 · 2013-07-26T20:49:13Z

Answer by Flora H. · Jul 26, 2013 at 08:49 PM

Thanks Stefan. So I guess we will have to open a support call piror to the migration?

0 Show 1 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Stefan G. · Jul 29, 2013 at 07:38 AM 0

Share

The product does not support the migration as a built in feature so there is no official support for it. But maybe professional services or so

stefan

Answer 3 · 2014-10-03T07:41:36Z

Answer by Ronald M. · Oct 03, 2014 at 07:41 AM

I am the same position as Flora, too. We are planning to migrate from PostgreSQL to Oracle. Can anyone form Compuware comment on the affect of version difference in PSQL and Oracle, please? Unfortunately, we are falling behind the version update in dynaTrace as well V4.2 in production with PSQL 8.4.4. What issue we might be facing when we migrate to dynaTrace 6 with Oracle 11g?

Thanks!

-Ronald

0 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Answer 4 · 2014-10-03T16:20:20Z

Answer by Stefan G. · Oct 03, 2014 at 04:20 PM

Hi, you should not experience any difference in changing the backend, the product is taking care of. The only problem is moving data from postgre to oracle which causes some downtime. As stated above the product has no built in support to migrate the data from postgre to oracle this has to be done by using external tools etc...

-stefan

0 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Migrate PW from Postgresql to Oracle

4 Replies

How to get started

NAM 2019 SP5 is available

LIVE WEBINAR

Follow this Question

Forum Tags