Migration from Oracle Server 12 DB to InfluxDB

Store
1

Hi InfluxDB community,

Do you know if there is an easy way of migrating data from an Oracle Server 12 DB to an InfluxDB system?
We have some Oracle systems and we would like to migrate its data to the InfluxDB system:

  • Is it feasable?
  • How could this be done in an easy way?
  • Could we verify the data consistency in some way (e.g: by using the Anti-Entropy from InfluxDB-EE)?
2

Hi @mrosanes -

Migrating depends entirely on the structure of your existing data. You’ll want to take your existing schema and map it to an InfluxDB timeseries schema. You will need tooling to pull data from Oracle, convert it, and then push to Influx. If you’re looking for a custom solution, please contact our sales team Contact Our Sales Team | InfluxData.

For checking data consistency, you could use group-by queries of Oracle and Influx data and compare counts.