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
Selecting information from 2 DB´s
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Selecting information from 2 DB´s
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.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.