topic Risk of migrating data from oracle to MS sql in High Availability and Disaster Recovery Questions

Risk of migrating data from oracle to MS sql

Bmohammad — Sat, 21 Nov 2020 07:45:46 GMT

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

Re: Risk of migrating data from oracle to MS sql

George_Thompson — Mon, 30 Nov 2020 17:15:51 GMT

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.

Re: Risk of migrating data from oracle to MS sql

Bmohammad — Mon, 30 Nov 2020 07:45:21 GMT

Thanks George