We are planning to Migrating performance warehouse from Oracle to MS SQL . Is there any best practice to do that ? If so please suggest us.
currently this is not supported in the sense that we don't provide any scripts or procedures for it (there should be tools out there that can migrate a database from Oracle to SQL Server, we're not using any complex stuff, so it should be relatively easy).
However, we're planning to support this with the next release (6.5), on a per-system-profile basis. Best regards,
yes, the feature is in 6.5 as a beta implementation. It works on a system profile basis and can be scheduled from inside the dynatrace client in debug mode.
We only have internal documentation so far, so please open a support ticket, we'll provide you with instructions (refer to this forum discussion if you wish).
To all who read this in the future, in 7.0 this feature will be standard and should be documented normally. Best regards,
In theory yes. The migration feature will be based on migrating data for specific system profiles, so the source dt server isn't that important, you just need to give it a source database server.