Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I need to make an inner join sql query to several SQL Servers (one is 2000 and another is 2008 R2). The query is like the following:

SELECT 
   k.ID, k.NAME, k.BIRTH, l.PROFILEID 
FROM 
   CUSTOMERS..REGISTRY k 
INNER JOIN
   SECURITY..USERS l ON K.ID = l.ID

The CUSTOMERS..REGISTRY is on the 2008 R2 and SECURITY..USERS is on the 2000 servers. The servers are situated in different networks, connected through internet. Is there any way to organize such query?

share|improve this question
add comment

2 Answers

up vote 4 down vote accepted

The servers are situated in different networks, connected through internet.

Preferably, don't do that.

VPN and (as AceCTO suggested) linked servers if you must but if this is a query you want to run regularly, move the data. BCP it, replicate it, log ship it... just move it.

share|improve this answer
    
Thanks for advice, my experiments with linked servers showed that you are right –  voo Feb 28 '13 at 7:46
add comment

You appear to need linked servers:

Microsoft SQL Server Linked Servers

You can attach the 2000 instance from the 2008 server to use in your queries, depending on the amount of data and connection speed the performance may not be acceptable.

share|improve this answer
2  
I have some serious security concerns about trying to establish linked servers over an open internet connection. I would make sure to secure this connection if I were going to use this. –  Mike Fal Feb 25 '13 at 23:13
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.