Oracle to Postgresql

166
3
10-09-2020 04:28 AM
SumanD
by
New Contributor III

We are planning to conduct a prototype to migrate data from Oracle to postgresql. Is there any standard guidelines/documentation available for the migration? 

This would not only include the data, but migrating the user roles, privileges, logins etc. any standard guide outlining the best principles would be helpful

The target version of ArcGIS would 10.8 (current version ArcGIS 10.2.1). We will have ArcFM in the existing and the target environment

0 Kudos
3 Replies
George_Thompson
Esri Frequent Contributor

I usually recommend using Copy / Paste, ArcPy, FME. This is the safest way to migrate the data over. We do not have any "tools" that will do it directly. Using 3rd party tools to migrate the data may not work as expected due to the geodatabase behavior.

--- George T.
0 Kudos
SumanD
by
New Contributor III

Well there are a few complex stuff to deal:

1. The DB has ArcFM implemented

2. The database objects are in Geometric Network

3. Few feature classes have more than a couple of million records, and these FCs have tables related to it. So copy/paste may hang the system

3. Source version Oracle 12/ArcSDE 10.2.1- target Postgres/ArcSDE 10.8

I am contemplating one of the following options:-

1. Use FME

2. Convert source data to FGDB, then move to target Postgres

4. Use ArcPy (Append/copy/load) tools

3. A combination of all the above options

Please advise

0 Kudos
George_Thompson
Esri Frequent Contributor

I can appreciate and understand the complexity with the migration, especially with ArcFM involved.

Doing the option #2 below is a good one, very similar to the copy/paste directly method.

I am contemplating one of the following options:-

1. .....

2. Convert source data to FGDB, then move to target Postgres

Using the Copy/Paste should bring over all of the related data, Geometric Network, etc.

You will need to make sure that you reconcile / post all versions (delete after edits posted), then get a full compress before copying over data. This will prevent losing any edits in a version.

--- George T.