What's a good off-the-shelf tool that can be used to perform replication between mysql and oracle in both directions? We're currently looking at DBMoto which is super, but I was hoping there was something less expensive.
The requirements are:
- Easy to configure and maintain through a GUI.
- Table-level replication selection, with configurable criteria (such as date > last_replication_time).
- Does not have to be real-time.
- Capable of handling large volumes of data efficiently (20gb+).
- Selective indexing, for example, target system might need more or less indexes.
- Maintenance-free adjustment to schema changes.
- Alerts when replication fails for some reason, emailing discarded records.
- Reports that show how many records are replicated.
- Not expensive (we have maybe a $5000 budget).
- Preferable to not impact source system, but allowable.