To merge two CAS into one. How do I 'merge' their databases?
Here's the scenario:
Initially I have two CAS, where they are reside in two different Server A and Server B.
Now, after upgrade them to NAM. I would like to migrate these two NAM Servers into one new server, server C.
How would I do that? For example, I would have one mdf file from server A, and also another mdf file from server B. After transferring these two mdf files to server C (to prepare for migration). How should I proceed?
Also btw, please let me know if there is any other important consideration I need to think about, other than this one.
Thanks in advanced!
Best Regards,
Wai Keat
Best Answer
Hi,
Actual merge of the databases is not possible.
There are several alternatives you can think of:
Run two CASes on a single host, on different ports, connecting them as a farm. From an external user perspective, this will be a single host. Same perspective for an infrastructure manager: a single server. But internally there will be two CAS JVMs and two CAS databases on this host.
If traffic analyzed is moderate, you can also think of "freezing" CAS B and using CAS A as the only server that processes AMD data. Still keeping them in a farm configuration. Over time, CAS B will serve only historical data and you would be able to decommission it completely when historical data won't be needed anymore.
Those two options are not exclusive, you can use both at the same time.
Best regards
Community Member of the Month
September 2019
Announcing Dynatrace's Community Member of the Month for September 2019, Chad T.! Click here to read more! Employee Member of the Month
September 2019
Announcing Dynatrace's Employee Member of the Month for September 2019, Matthias H.! Click here to read more! 
