Replicate sequences vs exp/imp sequences for migration using Golden Gate
edited Sep 13, 2013 12:31PM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered ✓
Hello,
I am testing doing a migration from 10g on unix to 11g in Linux using Golden Gate.
Only 4 schemas contain the data for the application, the rest of usernames don't have any application objects.
One of the things I have seen as an issue is the sequences, our system is highly transactional but in the case of a maintenance I can work with some idle/offline time. Having these factors I am thinking I can configure the table replication for the schemas and do:
- Keep the table replication going until the window where the 11g database will be the production database. No use any sequence replication.
I am testing doing a migration from 10g on unix to 11g in Linux using Golden Gate.
Only 4 schemas contain the data for the application, the rest of usernames don't have any application objects.
One of the things I have seen as an issue is the sequences, our system is highly transactional but in the case of a maintenance I can work with some idle/offline time. Having these factors I am thinking I can configure the table replication for the schemas and do:
- Keep the table replication going until the window where the 11g database will be the production database. No use any sequence replication.
0