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 a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.