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

Reply via email to