Replace the Linked server

Question

Replace the Linked server

Sony Francis @EY

SSCommitted

Points: 1539
More actions
May 9, 2012 at 3:38 am

#392216

Our company has used Linked server to get the other db server data . Now we are trying to replace the linked server with SSIS package. Package can run in a sheduled mannar. So we could not get the live data.
Is any other way to replace the linked server for getting the live data ?.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Divine Flame SSCoach Points: 15943 More actions · Answer 1

Sony Francis @EY (5/9/2012)
Our company has used Linked server to get the other db server data . Now we are trying to replace the linked server with SSIS package. Package can run in a sheduled mannar. So we could not get the live data.
Is any other way to replace the linked server for getting the live data ?.

Have you considerd Transactional Replication?

Sujeet Singh

vinu512 SSCoach Points: 15729 More actions · Answer 2

Divine Flame (5/9/2012)
Sony Francis @EY (5/9/2012)
Our company has used Linked server to get the other db server data . Now we are trying to replace the linked server with SSIS package. Package can run in a sheduled mannar. So we could not get the live data.
Is any other way to replace the linked server for getting the live data ?.
Have you considerd Transactional Replication?

+1

You should read about Transactional Replication

Vinu Vijayan

For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

Sony Francis @EY SSCommitted Points: 1539 More actions · Answer 3

Any way other than replication ?

Replication requires additional hardware( subscriber and distributer server). Expensiveeee!!!!!!!!!

Ant-Green SSC Guru Points: 113507 More actions · Answer 4

Sony Francis @EY (5/9/2012)
Any way other than replication ?
Replication requires additional hardware( subscriber and distributer server). Expensiveeee!!!!!!!!!

the publisher and distibution server can be the same box, so that would be the linked server box, the subscriber would be the server which you are running the query from. that way you can do cross database queries rather than cross server queries. so no additional hardware required.

Divine Flame SSCoach Points: 15943 More actions · Answer 5

Sony Francis @EY (5/9/2012)
Any way other than replication ?
Replication requires additional hardware( subscriber and distributer server). Expensiveeee!!!!!!!!!

Seriously ??? You said that you are using linked server already to get the data from other servers. That means you have 2 separate instances. To configure transactional replication thats all you need in terms of hardware (you can make your publisher server as the distributor also) !!!

Sujeet Singh