import data from MySQL to ArgGIS Server

361
1
01-27-2014 10:11 AM
MarkWebb
New Contributor II
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.

Thank you,
Mark
0 Kudos
1 Reply
BruceHarold
Esri Regular Contributor
Hello Mark

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.

Regards
0 Kudos