Print Page | Close Window

Collecting information from several similar databases

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce Classic
Forum Discription: For .NET 2.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=782
Printed Date: 28-Mar-2025 at 3:05am


Topic: Collecting information from several similar databases
Posted By: jcdk
Subject: Collecting information from several similar databases
Date Posted: 23-Apr-2008 at 1:00pm
Hi all
 
I would like to collect information from several similar databases and present it in one grid.
 
Say I have any number of databases with identical schema. In each database there is a table called Task with  a number of columns, among them an owner ID. Then I would like to show all the Tasks with the same owner ID from all the databases in ONE grid.
 
Is this possible? Any thoughts, ideas and pointers are greatly appriciated.
 
Regards
Jesper Carstensen


Print Page | Close Window