[pgrouting-users] pgRouting with SQL server?

pgRouting pgrouting-users
1

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

2

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@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

3

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

Many thanks Daniel!

Christina

From: pgrouting-users-bounces@lists.osgeo.org [mailto:pgrouting-users-bounces@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@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de