Changes between Version 8 and Version 9 of HowToMoveFromMySQLToPostgres


Ignore:
Timestamp:
Jul 13, 2009, 12:15:24 AM (15 years ago)
Author:
heikki
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • HowToMoveFromMySQLToPostgres

    v8 v9  
    9898=== Exporting existing data from MySQL and importing it into Postgres ===
    9999
    100 TODO describe the process
     100There are many ways to achieve this, and all of them require manual fiddling with data dumps and things like that.
     101
     102Many thanks to Thijs Brentjens who gave this excellent tip, I've found a relatively straightforward way of doing it using the tool [http://www.gdal.org/ogr2ogr.html ogr2ogr] which is part of the [http://www.gdal.org/index.html GDAL] tool suite. The ogr2ogr build I found on their web site does not include drivers for MySQL and Postgress though. Downloading the tool suite [http://fwtools.maptools.org/ FWTools], which includes GDAL, solved this.
    101103
    102104=== Links to related information ===