If you have time and interest in seeing the pieces in the middle (or just not that much data), you could go:
- pgsql2shp (shapefile intermediate) and then use the sqlspatialtools to load - OGR2OGR supports reading and writing at both ends of that pipe - part of me wants to suggest that a PG_DUMP to text would provide SQL that could then be consumed in SQL server. Let us know how you get on! These sorts of migration/interop journeys are always good reads! Regards, Sam On Mon, Jul 23, 2012 at 8:43 PM, james butler <butler.jam...@gmail.com>wrote: > I need to move some spatial data back and fourth between these 2 databases. > > What is the best method and are the data formats the same? > > thanks > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users