[pgrouting-users] pgRouting with SQL server?

[Mitsakou, Christina]

I might need to try this, I'll keep you informed.

Many thanks Daniel!

Christina

From: pgrouting-users-bounces at lists.osgeo.org [mailto:pgrouting-users-bounces at lists.osgeo.org] On Behalf Of Daniel Kastl
Sent: 20 June 2012 15:51
To: pgRouting users mailing list
Subject: Re: [pgrouting-users] pgRouting with SQL server?

Hi Christina,

pgRouting requires PostGIS and PostgreSQL, so you can't install it on a different database management system.

Eventually it's possible to use a new PostgreSQL feature called "Foreign data wrappers" [1] [2] to access data outside PostgreSQL, which allows to treat the data source like a table. But I haven't tried this yet and can't tell it works for SQL Server nor how it performs.

Daniel


[1] http://www.postgresql.org/docs/9.1/static/ddl-foreign-data.html
[2] http://wiki.postgresql.org/wiki/Foreign_data_wrappers


On Wed, Jun 20, 2012 at 4:33 PM, Mitsakou, Christina <christina.mitsakou at kcl.ac.uk<mailto:christina.mitsakou at kcl.ac.uk>> wrote:
Hi everyone

I would like to ask if any pgRouting user has any experience on the following:

1)      Would it be possible to use pgRouting with other database management system rather than PostgreSQL (e.g. SQL server)?

2)      If we install on a server both systems (PostgreSQL, SQL server) would it produce any server failure?

I appreciate your comments on the above points.

Thanks
Christina


_______________________________________________
Pgrouting-users mailing list
Pgrouting-users at lists.osgeo.org<mailto:Pgrouting-users at lists.osgeo.org>
http://lists.osgeo.org/mailman/listinfo/pgrouting-users



--
Georepublic UG & Georepublic Japan
eMail: daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de>
Web: http://georepublic.de<http://georepublic.de/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20120620/dff10811/attachment-0001.html>