Question Re: Sybase version 15.7 migration in Technology Q&A

Sybase version 15.7 migration

Former Member — Fri, 09 Feb 2018 15:40:29 GMT

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

Re: Sybase version 15.7 migration

Mark_A_Parsons — Fri, 09 Feb 2018 17:54:17 GMT

I would suggest you ask that 'Sybase guy' for details of what s/he is talking about.

Re: Sybase version 15.7 migration

former_member89972 — Fri, 09 Feb 2018 21:20:15 GMT

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.

HTH

Re: Sybase version 15.7 migration

Arbi_TM — Tue, 13 Feb 2018 01:38:21 GMT

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

Cheers.

Re: Sybase version 15.7 migration

Former Member — Wed, 14 Feb 2018 05:42:46 GMT

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.

Re: Sybase version 15.7 migration

Former Member — Wed, 14 Feb 2018 05:43:22 GMT

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.

Re: Sybase version 15.7 migration

Arbi_TM — Fri, 23 Feb 2018 02:47:01 GMT

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.

Cheers.