Skip to Content

Sybase version 15.7 migration

Hello Experts,

In one of the old Datacenter there are few sybase ASE 15.7 servers on physical machines, planning to migrate all sybase ASE to new datacenter AS IS on physical machines,

I was looking at the best possible approach,

Approach 1:

a) build physical machines

b) install Linux

c) install sybase 15.7

d) backup database from old DC and restore databases to new DC.

e) backup logins from old DC restore to new DC

Approach 2:

I heard from one of the Sybase guy that there is some way of migration sybase ASE which can reduce sybase building efforts and backup restore efforts alot, there is some way which can copy the same sybase stuffs from old server to new server. just wanted to know about this approach like what it is if any body can explain or guide

Thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Feb 09, 2018 at 09:20 PM

    If you are allowed to physically transport all related hardware from old DC to new DC that would be the simplest way.

    Risk is during the transport hardware may be subjected to physical and thermal shocks and it may not function as expected when it arrives at new location. Also this will involve prolonged downtime.You may need to tweak IP addresses to match your scheme from old DC to new DC.

    If it is on a totally new harware in new DC then backup-restore is the route.

    If it is backup and restore then you have to follow long route of

    - building new servers with matching storage, synchronzing security/logins and

    - then restore user databases,

    - run through sanity checks and

    - then release to users.

    If replication is involved you have to be even more careful to re-establish similar matching pipelines too.

    Any data center move is a set of challanges you have to plan for meticulously and then execute.


    Add comment
    10|10000 characters needed characters exceeded

  • Feb 14, 2018 at 05:42 AM

    thanks Tony,

    is there a way by copying complete volumes or filesystem from source servers( old datacenter )to target server (New datacenter)? lets consider standalone sybase instance first?

    can you share the content of system copy as i am not able to go to shared links.

    can it be used to migrate sybase ASE 15.7 (standalone) on linux machine.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 13, 2018 at 01:38 AM

    Hello Sachin,

    I suppose you are referring to standalone ASE database migration?

    This is the note talking about the procedures: 2074211 - Cross platform database migration - SAP ASE

    I think the "easier" way mentioned by some sybase guy should be system copy, which is used only for ASE database on business suite.

    2379836 - Homogeneous or Heterogeneous system copy in case of minor OS change

    2542361 - System copy/migration with sybase database - SAP ASE for BS


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Sachin,

      I'm afraid there's no easier way to copy complete volumes or filesystems from old DC to new DC.

      The system copy method is for ASE on business suite only. It could not be used for standalone ASE systems.