I have SQLite file which I have taken it from Sptialite DB. I need to convert this file into SDO. Plz help me

  • 1
    Welcome to GIS.SE. Have you tried anything? This sort of question, please give me a library, code, is generally frowned upon, as it shows no effort. Here is an Stack Overflow question that might help get you started. – John Powell Feb 16 '15 at 8:20
  • 2
    ogr2ogr will do it – Ian Turton Feb 16 '15 at 8:38
  • @iant. I am starting to realize that ogr2ogr does everything. I wish the docs were a bit more volumninous, sometimes, though.- – John Powell Feb 16 '15 at 9:07
  • @iant. I tried in ogr2ogr but in that there is option to export oracle directly.. – Sid Feb 16 '15 at 11:44
  • You need to have GDAL with OCI support. It is not compiled by default because you must explicitly agree with the terms. Gisinternals.com has a plugin with installer if you are on Windows. – user30184 Feb 16 '15 at 12:56

You can use OGR2OGR to do this, writing to Oracle is through the OCI driver; reading from SpatialLite is by through the SQLite driver so something like:

ogr2ogr -f OCI OCI:warmerda/password@gdal800.dreadfest.com db.sqlite 

should do it.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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