Selecting information from 2 DB´s

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
JORGEMAL
Posts: 168
Joined: Thu 03 Jul 2008 23:55

Selecting information from 2 DB´s

Post by JORGEMAL » Thu 30 Jan 2014 15:53

Is it possible to perform a select statement to retrieve data from 2 databases located in 2 different servers and get the result in, let´s say, one DataReader or one DataTable?

One approach for getting the information into a DataTable is to perform 2 selects, fill 2 different DataTables and, finally, do a DataTable merge. However, I am interested in knowing if there is an approach to do all this in only one step, with one query, one pgsqlConnection, one pgsqlCommand.

Respectfully,
Jorge Maldonado

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: Selecting information from 2 DB´s

Post by Pinturiccio » Fri 31 Jan 2014 16:31

I am interested in knowing if there is an approach to do all this in only one step, with one query, one pgsqlConnection, one pgsqlCommand.
PgSqlConnection can establish a connection only to one PostgreSQL database at the same time. This is the designed behaviour so there is no an approach to select data from two databases in one DataTable in one step with dotConnect for PostgreSQL.

Post Reply