Migrating spatialite 3 databases to spatialite 4 database

[aidan murphy]

I am trying to migrate several databases containing user entered geometry data from a spatialite 3 db to spatialite 4.  If I run InitSpatialMetaData in my migration scripts I receive errors saying that certain metadata columns already exist.  There is no function to De-InitSpatialMetaData, so my thought was to drop all the spatialite meta data tables individually, then run InitSpatialMetaData, and then use RecoverGeometryColumn to grab all my metadata again.  I ran a simple test and it seems to have worked.  Though there is a very discerning message I read that says Directly performing INSERT, UPDATE or DELETE on their behalf is a completely unsafe and strongly discouraged practice.  

Is there some other safer way to do this?

Thank you!

[a.fu...@lqt.it]

On Wed, 29 Jul 2015 09:43:08 -0700 (PDT), aidan murphy wrote:
> Is there some other safer way to do this?
>

Hi Aidan,

there is a specific spatialite-tool exactly intended to support any
format conversion between different versions in the safest way.

https://www.gaia-gis.it/fossil/libspatialite/wiki?name=switching-to-4.0#convert

bye Sandro

[Pac]

Hi Aidan,

After upgrading your metadata tables with spatialite_convert (it works like a breeze), you should consider to update its statistics tables (https://www.gaia-gis.it/fossil/libspatialite/wiki?name=metadata-4.0) executing UpdateLayerStatistics function (look for it in http://www.gaia-gis.it/gaia-sins/spatialite-sql-4.3.0.html#p16).

Regards,
Paco.