G
gus
Guest
Pro2 and OpenEdge Replication are very different in how they work. here is a very rudimentary summary of differences. Pro2 relies on 4GL triggers on all those tables that are being replicated. Could be all or only one. These triggers record entries in a "change log". When SQL is used for database updates, a second set of triggers is required. A background 4GL program then reads the change log and performs the equivalent operations on the target database(s). schema changes are not replicated. target database does not have to be identical to source. index rebuilds do not break replication. works best when every table being replicated has a unique index but that is not required. every database change in source causes a record to be created in the change log. that record also has to be deleted. transaction sizes increase significantly. oe replication is /all/ database changes to an identical oe database (i.e. an exact copy of source). schema changes are replicated. replication is done by shipping transaction log records (ai records) from source to target and performing the exact same operations on the target. no triggers are used. many maintenance operations like an index rebuild will break replication which then has to be started over. disabling ai, which is sometimes necessary, breaks replication. gus > On Dec 1, 2015, at 12:30 PM, eswarm wrote: > > Update from Progress Community [https://community.progress.com/] > > eswarm [https://community.progress.com/members/eswarm] > > We've been using Fathom Replication Plus for last 10+ years, it works efficiently but finds very difficult to maintain during server outages. Rebuilding the Replication is really a painful task and effects our business hugely. > > I was exploring the options to migrate to Openedge PRO2. I'm fairly new to PRO2, after few research it sounds that it delivers all the features that is built in Replication plus and additionally it allows data to be exported to other platform. > > It'll be grateful if anyone could share your experiences with PRO2 and reasons why shouldn't be migrating to PRO2 from Replication Plus. > > Also, I couldn't find a document/wiki on comparison of features, benefits between PRO2 and Replication Plus. > > Any inputs will really help me to make right decision. > > Thank You, > > View online [https://community.progress.com/community_groups/openedge_rdbms/f/18/t/21716] > > You received this notification because you subscribed to the forum. To stop receiving updates from only this thread, go here [https://community.progress.com/community_groups/openedge_rdbms/f/18/t/21716/mute]. > > Flag [https://community.progress.com/community_groups/openedge_rdbms/f/18/t/21716?AbuseContentId=60aa8ed4-843e-47e4-8249-cca4c55d1050&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true] this post as spam/abuse.
Continue reading...
Continue reading...