Board index » delphi » Multiple DB/multiple DB servers -> 1 dataset

Multiple DB/multiple DB servers -> 1 dataset


2005-05-03 03:34:21 AM
delphi76
I want to create a dataset that is composed of records of mutiple tables
with identical structures. The catch is that these tables are in different
databases on different MS SQL Server database servers. Can anybody think of
a way of neatly doing this with a delphi componet, third party component,
stored procedure?
Pat Ryan
 
 

Re:Multiple DB/multiple DB servers -> 1 dataset

you can use Partitioned View
see in the help of MS SQLServers the topic Creating a Partitioned View
charles