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 05, 2009 11:40 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, December 20, 2010 4:47 AM
Points: 42, Visits: 141
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 06, 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 06, 2009 12:38 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, April 18, 2014 6:27 AM
Points: 6,997, Visits: 8,411
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 06, 2009 6:18 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 11:22 PM
Points: 2,018, Visits: 65
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