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

Moving SQL Performance warehouse from one host to another

jared_kemp
Organizer

Are there instructions on migrating our Performance warehouse database on SQL Server from one host to another? Our DBA wasn't sure what all a move would entail from a dynatrace side to make sure we didn't lose anything.

4 REPLIES 4

Hi Jared,

I have done one warehouse "transplant" before and we didn't have to do anything. We just copied the DB across and re-pointed the DT server to it.

Regards

Flo

ok, I am guessing I should disconnect the PW first before we move it, then update the information and reconnect it?

The steps would be like below:

- install the new performance warehouse

- copy the schema and content of all tables _except_ for the measurement_*, percentiles_* and blmeasurements tables

- disconnect the dt server from the old pwh, connect it to the new one, it'll start writing immediately with the correct metadata

- copy over the contents of the tables you left out before (mentioned above

Which I found in this post: https://answers.dynatrace.com/questions/149382/what-and-how-much-data-will-be-kept-after-a-planne.html

thanks a lot!