TransWikia.com

Migrate MySQL spatial DB/tables to PostgreSQL

Geographic Information Systems Asked by Maurocrispin on May 6, 2021

We have a web system that uses MySQL spatial databases. We want to migrate from MySQL to PostgreSQL. I’ve been looking for methods to do it. I have found some tools that help you to migrate. However most of them do not support spatial data like https://github.com/philipsoutham/py-mysql2pgsql.

I also took a look over How to migrate spatial tables from MSSQL to PostGIS. I have just seen this post. I haven’t tried it yet, I don’t know if it could work for MySQL.

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP