Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Connect two servers Expand / Collapse
Author
Message
Posted Thursday, February 5, 2009 11:40 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 10, 2014 7:52 AM
Points: 42, Visits: 142
Hi,

Can you explain me the different ways of how a database (Database1) in server (Srvr1) can be connected to a database (Database2) in server (Srvr2) using a query?

I have admin access to both databases mentioned above with valid credentials.

Thanks in advance.


"I Love Walking In The Rain So No One Can See Me Crying ! " ~ Charlie Chaplin
Post #651409
Posted Friday, February 6, 2009 12:17 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 24, 2012 8:11 AM
Points: 1,097, Visits: 2,157
What are your tasks though? Is it just connecting to the database. Could you provide us with more info?

You can do this in many ways:
Linked server
Replication
Logshipping
DB Mirroring
Failover Cluster

But what is your objective though?
Post #651421
Posted Friday, February 6, 2009 12:38 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 7:42 AM
Points: 6,743, Visits: 8,515
You can do it ... but should you ???

http://www.sqlservercentral.com/Forums/Topic639157-360-1.aspx


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #651429
Posted Friday, February 6, 2009 6:18 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, July 18, 2014 12:04 PM
Points: 2,256, Visits: 68
Hi,

You can use it by creating Linked server. Another way is openquery and opendatasource functions.
Post #651551
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse