Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Fetch data from two database servers in sql

Status
Not open for further replies.
sivasivasivasivasiva

sivasivasivasivasiva

Programmer
Dec 16, 2003
5
HK
Hello,
I have two different database servers.One is my live database and another one is my archieve database.Now i want to get all the records for a specific search condition from these databases in a single sql statements.

Thanks in advance

Sivaraman
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

Pauljohn44
  • Locked
  • Question
Pivot data with two key fields
Replies
0
Views
157
Pauljohn44
Pauljohn44
gdg1976
  • Locked
  • Question
db2 sql extract double rows (different in case sensitive) 1
Replies
6
Views
250
mikrom
mikrom
MichaelDe
  • Locked
  • Question
SQL Update with File Join
Replies
10
Views
999
MichaelDe
MichaelDe
handle907
  • Locked
  • Question
ADM10501W - Health indicator "Database Automatic Storage Utilization"
Replies
0
Views
358
handle907
handle907
walter.weinmann
  • Locked
  • Question
Docker Iage IBM Db2 11.5.6.0: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001
Replies
0
Views
303
walter.weinmann
walter.weinmann

Part and Inventory Search

Sponsor

Back
Top