Member Avatar for En-Motion

I have two databases on two different servers. I want to connect two tables based on an id but I'm not sure how to do it. I've seen stuff like this suggested

<server name1>.<DB name1>.<schema/owner name1>.<table name1>
JOIN
<server name2>.<DB name2>.<schema/owner name2>.<table name2>
ON <...>

but I can't get it to work. How do I make two simulataneous connections to two databases on different servers?

  • 2 Contributors
  • 1 Reply
  • 79 Views
  • 2 Weeks Discussion Span
  • Latest Post Latest Post by Ankit_Parmar
Member Avatar for Ankit_Parmar

Firstly,You will fetch table from both server and store in temp table on any server(Where you want to create that combined table) and after that you can join that tables.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.