Risk of migrating data from oracle to MS sql

55
1
Friday
Highlighted
New Contributor III

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

Reply
0 Kudos
1 Reply
Highlighted
Esri Frequent Contributor

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 / Past 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.

 

--- George T.