I am trying to import a very large sqlite file into Postgres SQL 9.3.
The first tool I tried to use was OGR2GUI (http://www.ogr2gui.ca/). The 64 Bit version does nothing, whilst the 32 bit version says
- unable to open ogr2ogr !
I have tried running org2ogr from the command line too, I have tried:
ogr2ogr --config SQLITE_LIST_ALL_TABLES YES -f "PostgreSQL" PG:"dbname='mydatabaseName' active_schema=myschema schemas=public host='localhost' port='myportnumber' user='myusername' password='mypassword' " -overwrite -lco SCHEMA=myschema -lco GEOMETRY_NAME=geometry -lco SPATIAL_INDEX=YES myfilename.sqlite myfilename
ogr2ogr -f "PostgreSQL" PG:"dbname=mydatabaseName" myfilename.sqlite myfilename
ogr2ogr -f PostgreSQL PG:"host=localhost user=myusername password=mypassword dbname=mydatabaseName" -lco LAUNDER="YES" myfilename.sqlite -skipfailures
And various iterations on these, each time I get:
Unable to open datasource'myfilename.sqlite' with the following drivers
-> ESRI Shapefile
-> MapInfo File
-> UK .NTF
-> SDTS
-> TIGER
-> S57
-> DGN
-> VRT
-> REC
-> Memory
-> BNA
-> CSV
-> GML
-> GPX
-> KML
-> GeoJSON
-> GMT
-> WAsP
-> PostgreSQL
-> PCIDSK
-> OpenFileGDB
-> XPlane
-> AVCBin
-> AVCE00
-> DXF
-> Geoconcept
-> GeoRSS
-> GPSTrackMaker
-> PGDump
-> GPSBabel
-> SUA
-> OpenAir
-> PDS
-> HTF
-> AeronavFAA
-> EDIGEO
-> SVG
-> Idrisi
-> ARCGEN
-> SEGUKOOA
-> SEGY
-> PDF
-> SXF
Of course sqlite is not on this list, but how can I add it?
I have tried running osgeo set-up, but there is no option I can find to add it.