Post reply

what is the alternative solutions to linked server?

  • August 9, 2009 at 8:15 am

    #213236

    what is the alternative solutions to linked server?

  • August 9, 2009 at 8:26 am

    #1036480

    depends on what you are trying to accomplish when you say "alternatives to a linked server"...gather data from sources outside of your server is probably what you mean, right?

    linked servers are very useful, as they present the data as a SQL table; you can use SSIS to connect and gather data instead of using a linked server.

    you can also use BCP or BULK INSERT to import from text files.

    you could also create your own application in a programming language to connect to both your SQL server and what would have been your linked server.

    what exactly are you contemplating? are you not supposed to create any linked servers?

    I personally use linked servers all the time; being able to connect to Oracle,MYSQL,Excel,Access, or even a folder full of text files , and treat them as a Table where I can select/update/insert/delete is extremely helpful.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • August 9, 2009 at 8:41 am

    #1036482

    thanks alot for your reply

    I mean by alternative solutions that I can access another server remotely

    I really didn't stablish any linked server before but I read that it becomes very slow with low speed connection and /or large amount of data

  • August 9, 2009 at 9:18 am

    #1036484

    yeah, with large amounts of data, usually what happens is the data is copied into your servers tempdb, manipulated, and then the answer is returned.

    whenever possible, you should use OPENQUERY on the data on the linked server, as that makes the work happen on the linked server, and only the results are returned back to your server; search SSC here for "openquery" to get some examples;

    in any case, performance is going to be worse than if the data resides on your local server.

    SELECT * FROM LinkedServer.DbName.dbo.MillionRowTable where name='bob' --copy all rows then filter

    vs

    select * from openquery(LINKEDSERVER,'SELECT * FROM MillionRowTable e where name=''bob'' ') --do the work on the remote server, return results

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • August 10, 2009 at 1:01 am

    #1036607

    thanx

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

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