[postgis-users] migrating mysql database with skt geometries into a postgis db?
Mr. Puneet Kishor
punk.kish at gmail.com
Fri Apr 20 06:52:13 PDT 2012
On Apr 20, 2012, at 12:38 AM, Robert Buckley wrote:
> I have this task....anyone got any tips on how to acheive thisß
I have been doing this, but it is not easy. Well, it may be easy for you, but it wasn't easy for me. The db I am working with is very complicated, so after banging my head against various approaches to dumping the data, cleaning it up, and trying to load it again in Pg, I gave up and simply selected each row in the MySQL db and inserted it into the Pg db. Took about a week writing the script correctly, and about 60 seconds to run it.
More information about the postgis-users