Sybase version 15.7 migration

[Mark_A_Parsons]

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

[Mark_A_Parsons]

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

[former_member89972]

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