V
Valeriy Bashkatov
Guest
Hi, It all depends on your application, number of users and transactional activity. Also from high availability and reliability requirements. You can replace OE Replication with AI Replication. But in this case, you will not be able to use the target database as a reporting server, while with OE Replication you can. Also, with AI Replication you will always have a gap between the Source database and the Target database. Because you will need time to archive the AI extents, package them, send them to another server, unpack and run AI Roll-Forward. OE CDC you can replace with Replication Triggers. But you will have to write separate trigger programs for CUD operations. You can also add your own application tables to save notes about the changes so that the ETL processes can process them later. The main disadvantage here is that in case of high transaction activity in the table your application will run slower than without them. This is because replication triggers are much slower than built into the database CDC triggers. In any case, OpenEdge is flexible enough to provide you with the features you need, whether it's built-in features or you'll be writing those features yourself. If you have time, you can do everything. All depends on you. Regards, Valeriy
Continue reading...
Continue reading...