Skip to Content

Sybase database migration from one datacenter to another datacenter

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 01, 2018 at 09:09 PM

    Not sure that I understand your question correctly:

    Do you mean to say that you have one datacenter (let's call it datacenterA) and another datacenter (datacenterB) and you want to migrate all the ASE instances from datacenterA to datacenterB?

    You mention that you currently have warmstandby and table replication. Is that warmstandby replication between ASE servers located entirely in datacenterA only? or between datacenterA and datacenterB?

    If you are going to migrate, my first recommendation would be warmstandby because it offers the possibility of creating replication paths from A to B, but if something goes wrong during or after your migration to B and you need to go back to A, you just switch the logical connection and this changes the direction of the replication. MSA cannot do that, it is a one-way replication mechanism.

    If you set up MSA replication from A to B and switch your users to B, only to find out that there are problems that require you to go back to A, then with MSA you would need to re-create the paths all over again in the opposite direction.

    Additionally, If you already use warmstandby replication, say from ASE sever 1 to ASE server 2, and want to migrate that data to ASE server 3, you can set up MSA replication to ASE Server 3 that will work from the logical warmstandby connection between ASE server1 and ASE sever2.


    Add comment
    10|10000 characters needed characters exceeded

  • Apr 10, 2018 at 07:46 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded