Skip to Content

Need to Change CMS, repoint to another CMC server of same database type

Apr 24, 2017 at 03:58 PM


avatar image
Former Member

Hi Everyone, We have a scenario where we need to change the existing deployment point to another CMS server of same db type (ie., sql server).

current scenario: Cluster of six production servers on 4.2 SP3 , windows 2012 R2

CMS & Audit: SQL Server 2012 in some datacenter (lets say A).

How do I make all my six prod servers point to another CMS server (different datacenter)

Point to note is. all the data gets replicated to this new db in different datacenter( its basically the HA DC). Now this new db has all the info of prod cluster, how do we ensure all the prod servers point to this new db ensuring the data is still intact.

Is it just Update Data source settings on the SIA would work? Provided I have the DSN pointing to the new CMS & Audit db?

We want to ensure nothing gets deleted or overwritten and the environment works as is post implementation of CMS pointing to new CMS & audit db.

Note: Both old and new cms databases are SQL servers only, its just that they are situated in different datacenters.



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Denis Konovalov
Apr 24, 2017 at 05:12 PM

If CMS DB content is replicated properly, then simply re-pointing Data Source in each SIA in the cluster will do the trick and nothing will be lost.

However, better idea is to make this proves invisible to the BI/BOE.
Make DNS change instead, so that original DSN's point to new DB instead, this way BOE won't even know things changed.

10 |10000 characters needed characters left characters exceeded