[postgis-users] migrating mysql database with skt geometries into a postgis db?

[Mr. Puneet Kishor]

On Apr 20, 2012, at 12:38 AM, Robert Buckley wrote:

> Hi,
> 
> 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.



--
Puneet Kishor