[Qgis-user] Re: [Newbie] Trying to get started with QGIS

[Goyo]

El día 9 de marzo de 2012 06:53, Lilirian <b137716 at rppkn.com> escribió:
> Hi Andreas,
>
> thanks kindly for your reply. It really really helps me! Because i'm using
> Sql Server 2008 (with geographies) I can 'export' the boundary as a GML
> (phew) .. which means I should be able to import it back into QGIS (based
> upon what you've said) :) :)
>
> /me goes off to give this a go ...
>
> I can get the WKT to import but not any GML :( I guess my GML is in an
> invalid format?
>
> http://pastie.org/3553482 this is the sample GML  which Sql Server 2008
> gives me.

It seems like you used AsGml to get a geometry in GML format, but
that's not like a "GML layer" which you can load in QGIS.

You should be able to export your data into shapefiles and other
formats using ogr2ogr (gdal >= 1.8):
http://alastaira.wordpress.com/2011/09/29/exporting-spatial-data-from-sql-server-to-esri-shapefile/
But if gdal can read MS SQL server data, I think QGIS sholud be able
to load it as well.

I have no experience using MS server so I don't know about the details.