Loading OS ITN GML files to SQL Server database

[rfromthecastle]

Hello,

I was wondering if you had a configuration file/example available to load Ordnance Survey ITN data in GML format into a SQL Server database.

[walkermatt]

Hi, I don't know of anyone that has used Loader to load ITN into MS SQL Server but it should be possible.

I would of thought that you would be able to use osmm_itn_postgres.gfs to define the output tables with little or no modification.

You would also need a suitable MS SQL Server ogr_cmd in your configuration. See the OGR MS SQL page for details.

The supplied views however will probably need some work as I'm not sure the array functions we use in Postgres are available in MS SQL Server.

I'd be happy to add a section to complement the [ITN Postgres section in the wiki]https://github.com/AstunTechnology/Loader/wiki/Configuration-examples#ordnance-survey-itn-to-postgresqlpostgis).