Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Data
  • 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.

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 

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.

Reply


Community Stats

30,353
Posts
115,359
Replies
38,089
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.