I have about 100GB of data in a MySQL database that contains geospatial information. I am interested in importing the data into ArgGIS Server 10.2 that is backed by a PostgreSQL database. Is there an easy way to do this? I may receive the data in the form of CSV data from a MySQL data dump and then I want to import it into a feature class. One thought I had was to import the data via GeoEvent Processor but I wanted to see if there is an easier way.
Could someone please provide me some help or resources on how to perform this task.
The Data Interoperability extension can be used to directly read MySQL (using MariaDB libraries) and write to PostgreSQL. 100GB of data is quite a batch, you may need to break the project into chunks if you perform any manipulations on the way.