C
ChUIMonster
Guest
We (WSS) took the CDC approach for the DBA Challenge in Prague. It worked quite well. Basically we enabled CDC and grabbed online backup. Restored the backup and dumped from that backup and loaded into the new structure. While that was happening we had CDC capturing changes. We loaded the changes and when everything was all caught up switched database. Total down time was miniscule. There was some 4gl coding required to dump the captured changes and then load them into the target. We did mess up slightly and forgot to grab sequence values.
Continue reading...
Continue reading...