A
Andriy Mishin
Guest
[quote user="ChUIMonster"] 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. [/quote] Thank you! That sounds interesting. But, unfortunately, we do not have a CDC license. >>There was some 4gl coding required to dump the captured changes and then load them into the target. As you identify a record in the target database? By a unique key? But if there is no unique key in the table, how in this case?
Continue reading...
Continue reading...