Maybe (and probably) this is stupid question, but I am totaly new to FME and geometry conversion.
I need to transform WKB field from SQLServer to GML geometry using FME software.
How can I do this?
MS SQL server Create new table or add new column. Use STGeomFromWKB to convert WKB to Geometry , then in FME do following.
Add "MS SQL spatial reader" , point it to correct table ( You can do this with SQLExecute too , that eliminates need for table containing geometry type and you can just use something like
SELECT STGeomFRomWKB(wkb) as geom , id from xxx ... ) and continue to use FME