If you were talking to someone whose organization is considering Oracle GoldenGate, what would you say?
How would you rate it and why? Any other tips or advice?
Oracle GoldenGate is a product that I would recommend. I would rate this solution a nine out of ten.
My opinion of GoldenGate is that it is an improvement over earlier Oracle products. I think that the interface for GoldenGate is very user-friendly. I recommend that people support the use of Oracle GoldenGate and have made this opinion known to colleagues in Egypt who are responsible for team projects. On a scale from one to ten — one being the worst and ten being the best — I would grade Oracle GoldenGate as a nine right now. After one or two more months working with the product, maybe the nine would be ten. It could be ten right now because I haven't faced any problems. This tool and Oracle's reputation speak for themselves. I don't need to complicate the issues by involving and a big problem I had in the past. But if I need a real reason why it should not be a ten and a nine is justified, I need Oracle to improve its support in Egypt. This is a genuine issue that is ongoing.
I would rate this solution around eight or nine out of ten. The solution is extremely stable.
This is a good solution for data replication, but there are some areas that need to be improved. I would rate this solution a seven out of ten.
This solution is priced well, is fast, and doesn't have any impact on our production database. I would rate this solution and eight out of ten.
I would recommend Oracle GoldenGate, of course.
You've got to balance the cost with your requirements. You may find that using something like Dbvisit Replicate is good enough for what you are doing, and it is substantially cheaper.