[postgis-users] Moving / Migrating PostGIS 9.1 with Geometry to MS SQL 2008

[Samuel Smith]

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.james1 at 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120723/d5a8eab9/attachment.html>