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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query for database to database

Status
Not open for further replies.
chrys204

chrys204

Technical User
Jan 15, 2008
1
US
I'm trying to compare the results of 2 tables on separate databases. Is there a single query I can run for the comparison? (i.e. remote Sybase db table to consolidated Sybase db table).

Thanks in advance,
Chrys
 
Sort by date Sort by votes
Create a proxy table.
You can then compare the tables as if they were on the same server.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

AM_WG
  • Locked
  • Question
Need help with SQL query to update a Micros report
Replies
0
Views
178
AM_WG
AM_WG
raphael75
  • Locked
  • Question
trying to call Sybase stored procedure with parameters from PHP
Replies
0
Views
130
raphael75
raphael75
baltman
  • Locked
  • Question
Precison too large error via Excel/ODBC solution needed
Replies
0
Views
130
baltman
baltman
sux2b
  • Locked
  • Question
How to find the version of the database
Replies
1
Views
92
mrdenny
mrdenny
iyethelen
  • Locked
  • Question
Help, i can't restore database ( suspect ), and get this message below
Replies
0
Views
69
iyethelen
iyethelen

Part and Inventory Search

Sponsor

Back
Top