CODEWITHSUNDEEP
sql-server
vijay kumar
vijay kumar

Reputation: 222

Querying data from two SQL servers without using Linked Server or OPENQUERY

I need to extract data from two databases which are on two different servers. But I can't use Linked server or OPENQUERY. Is there any other way to extract the data?

Upvotes: 1

Views: 2864

Answers (1)

David
David

Reputation: 1611

If you cannot use a Linked Server or Open Query, then you will have to migrate the data between environments. Those are the only ways to do cross-server queries.

There are multiple different ETL tools available that can move the information between environments, such as SSIS or Informatica.

It's worth noting that even with Linked Server connections that you can encounter performance issues and transactions which are held open from one end of the connection resulting in blocking transactions even when selecting very small amounts of information through the linked connection.

Upvotes: 2

Related Questions