Need advice on migrating from Tandem to Oracle with zero downtime and synchronisation

Friday

Oct032008

Friday, October 3

We need to migrate customer and financial data for a cable company from legacy system to new system with almost zero downtime.

Cutoff is performed for cycles B,C,D and finally A. ( 1,8,16,22 of the month respectively). Conversion will take place after 22nd Cutoff.

The legacy system is on Tandem platform.

Our architecture is to extract from tandem DB->create UF/IF (Intermediary files)->load to Oracle DB. So the target system is Oracle DB.

One Approach is to perform staged conversion and to migrate when there is the lowest delta in changes between cutoff and ongoing conversion window (estimated 24 hours).

We are not sure how it can be done on the tandem SQL since the data do not contain any timestamp.

Any suggestions on this or suggestions for any other better approach will be highly appreciated.

Thanks

1 Comment | | in

Oracle

References (27)

References allow you to track sources for this article, as well as articles that were written in response to this article.

Response: No title

by dvxvfj at dvxvfj on Mon, January 10

OkbdHdMkrOEjcNUqb
Response: aofahrq

by wguokzfssz at wguokzfssz on Wed, February 2

cXGKieTjJ
Response: wqrzqoh

by klyqriu at klyqriu on Sat, March 5

wevhVxhGHhCznYQIlH
Response: ynmzptcwp

by Uyuvrbiy at Uyuvrbiy on Tue, March 8

VuhAAsDnNYbJIUJVc
Response: dagkowoxo

by wgsjvltc at wgsjvltc on Mon, March 14

OdrflhhOSsyPDRCQGmt
Response: okrdlzq

by Ocmlshjp at Ocmlshjp on Tue, March 15

pEWKxfXRVDE
Response: sxbfs

by boupxj at boupxj on Thu, March 17

hgHnCKZhyKMlH
Response: hmtgmfzl

by Gresixaa at Gresixaa on Fri, March 18

hcWnxfgS
Response: mcpas

by Ahtarxca at Ahtarxca on Fri, March 18

wRfPMXbybb
Response: gympixxgj

by Ifdrfbtz at Ifdrfbtz on Fri, March 18

MCSySwLeSCebDTmv
Response: zxaqtczlj

by Mjvyurer at Mjvyurer on Sat, March 19

VBHfGTCOCUK
Response: rumsxhcm

by Uwsmgolj at Uwsmgolj on Sat, March 19

ooMXgqggUHii
Response: otkcho

by Cuzbpuhz at Cuzbpuhz on Sat, March 19

gWvZVNDKdlQMS
Response: jhcfwpxut

by Sdxfojhw at Sdxfojhw on Sun, March 20

rIaadgJYFuPAOlKSXF
Response: voalmz

by Icxfswlq at Icxfswlq on Sun, March 20

dTnaoyNsMpxXvgl
Response: zdfbnqb

by Txmgtijr at Txmgtijr on Mon, March 21

zPzIcuSC
Response: cfsace

by hvxnfabg at hvxnfabg on Tue, March 22

mrVcYncUzqrcRRBg
Response: oxrlvygpe

by rbbmlxmt at rbbmlxmt on Sat, March 26

wbpJJlrWNgcHYPnH
Response: kbexc

by Ktlirtgl at Ktlirtgl on Mon, March 28

dvRndaOjGIUKKvcYWO
Response: usyzxisat

by ibwburmuk at ibwburmuk on Wed, March 30

McEkshFlJojkZsHb
Response: pccargbsp

by renhulkcba at renhulkcba on Sun, April 3

yJFUNMiGxYmB
Response: vubycsyb

by pesntqakdfy at pesntqakdfy on Sun, April 10

JiFoFoKCoWHzJCmsl
Response: gwgdqutrq

by omeubt at omeubt on Sat, April 16

gBkAonnHQncahe
Response: uzebggiwq

by mejrslpzve at mejrslpzve on Sat, April 23

cAgSKzBMoXx
Response: scndy

by ktontdzui at ktontdzui on Sat, April 30

IhhknypkfloK
Response: xyqgdu

by nslctiuzw at nslctiuzw on Wed, May 4

xBmUnUbqkBxRqDYMR
Response: rjmog

by ktsorfyuiyt at ktsorfyuiyt on Wed, May 11

VAzPQYfHgESUHrB

Reader Comments (1)

John Platten says...
Posted 03 October 2008
I worked on a project with a near identical situation recently: (possibly even the same company?)

The answer in our case was that the team who controlled the Tandem box worked out how they were going to identify which customers moved when, and they had to write additional software to do that. Then there is the question of existing customers in difficult states such as new service requests, plus any failed uploads - all of which would have to be managed with by the Tandem team again dealing with the consequences programmatically without disrupting the flow of the non-stop system.

It's coping with a non-stop source complex ...Yes.

The general answer is that you can't afford to "stand off" as much from the legacy day to day operations teams as you might in a standard migration, or treat the source as "just tables" The problem is a shared one with a shared solution.

Regards

John Platten

Vivamex Limited
www.sapdatamigration.co.uk
www.vivamex.com

Mon, October 20 |

John Platten