Risk of migrating data from oracle to MS sql

Question

Dear All,

I want to migrate huge data from oracle spatial to MS Sql. I want to know what are the risk and what precatuiion should we take before migration processs

George_Thompson · Accepted Answer

How are you planning on migrating the data from Oracle to SQL Server?

I usually recommend something like the following;

* Old DB - Reconcile / Post / Delete versions / Compress (verify all delta tables empty)
* Copy / Paste into new Enterprise Geodatabase (From Old --> New)

There are lots of other items along the way that would be specific to your organization and workflows.

I would also make sure to have a verified back up of the data in the "old" geodatabase before starting the process.