I want to migrate my data (Shapefile) to a PostgresSQL using a FDOtoolbox , i searched a tutorial for that but i dont found it . can any one explain the steps to do for migarte the data from a database to another one.

  • Do you want to migrate from files to database or database to database? – artwork21 Mar 9 '15 at 16:35
  • From database to database. – Yahia El Haddad Mar 9 '15 at 16:46
  • Can you not do a backup and restore? – artwork21 Mar 9 '15 at 17:57
  • no the shapefile's backup is incompatible with a PostgresSQL , you should use a database migration tools. – Yahia El Haddad Mar 9 '15 at 18:23
  • From your comment, you are migrating from database to database. – artwork21 Mar 9 '15 at 19:20

Im not sure if you have to a FDOtoolbox solution or if that is just your preference, because another good option for this sort of work is ogr2ogr. Once it is installed you can just run something like this from the command line.

ogr2ogr -overwrite -f "PostgreSQL" PG:"host=myhost user=myuser dbname=mydb password=mypass" my_file.shp
  • I dont have just a shapefile i have multiple files and databases, files in arcgis (shapefile) and database on acces. Not jist a spatial files or databases – Yahia El Haddad Mar 10 '15 at 17:34

Not the answer you're looking for? Browse other questions tagged or ask your own question.