Sybase database migration from one datacenter to another datacenter

[#1]

Hi All,

i am planning to migrate database from one datacenter to another datacenter.

In the current envirnoment we have few few sybase ASE 15.7 Sp 138 mostly, currently we dont have any MSA replication setup in the current environment only warm standby and table level replication is there,

Since migration plan is like to setup MSA replication from old datacenter to new datacenter than failover it to new datacenter.

i will really appreciate if somebody can write up bullet points about.

amount of complexity to configure it in a running production environment, issues and risks including any additional licensing challenges.

thanks in advance

[sladebe]

I don't think MSA replication (aka whole database replication via subscription) will do what you want here.

It's *not* warm standby replication. There's no logical connection and no concept of "switch active" (switch replication direction).

I'm guessing you want to keep warm standby replication active in the old data center while you migrate to the new. If so, you could try setting up MSA replication to the new datacenter, disabling user access to the databases at the primary/standby/MSA replicate (so you can guarantee no data changes) then dropping replication and re-setting it up without materialization for the replicates.