Skip to main content
Question

How to Migrate Oracle Geodatabase (sde) to MySQL Database - ( MySQL FGDB Schema extracted from Oracle database in ArcGIS Pro) in FME Desktop. Which all possible Transformers can be used to migrate this data.

  • March 24, 2022
  • 1 reply
  • 30 views

actualabhijeet
Contributor
Forum|alt.badge.img+1

Firstly, we have extracted the Schema of this Oracle database (sde) in MySQL FGDB format in ArcGIS Pro exporting this schema.

Now, in FME Desktop I need to connect to Oracle database server and get this data as per feature classes present in datasets with all the attribution and its values with geometry in this MySQL FGDB Schema imported.

Need help on this and which transformers can be used to get this Oracle data migrated in MySQL database Schema FGDB.

 

image 

1 reply

redgeographics
Celebrity
Forum|alt.badge.img+49

If you simply want to make an A-to-B copy of your Oracle data into MySQL, you can probably get away with using the Generate Workspace option.

When it comes to which transformers you can use, it's a lot of them. That really depends on what you specifically want to do with your data (other than simply migrating it). If you can explain a bit more about your requirements it'll be easier for people here to try and help you.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings