Post reply

Alternative process except by doing using linked server?

  • October 9, 2012 at 11:34 pm

    #262995

    Hi SQLites,

    I want to update the data from one sql server to another sql server.

    Is there any alternative process except by doing using linked server?

    please let me know.

    Thanks

    GaNeSH

  • October 10, 2012 at 6:07 am

    #1547608

    Can you provide an example of a task based on what you need.

    In general if the data is distributed, you will have to use linked server or replication depending upon what you need. Linked servers are not very great but not very bad too especially if you know how to use them. for example, I prefer to avoid linked server in joins and instead fetch those columns with proper filters to local temp tables and use that. I can go to some more length here but first tell us what exactly is the requirement.

    Thanks

    Chandan

  • October 10, 2012 at 6:12 am

    #1547612

    You can transfer the data using ssis into stage table on target server and update.

    if the delay is acceptable and it is an repeating task.

  • October 10, 2012 at 6:22 am

    #1547615

    OPENROWSET is an option.

    http://msdn.microsoft.com/en-us/library/ms190312.aspx

  • October 10, 2012 at 6:30 am

    #1547618

    if you think about it at a little higher level, the question is :

    how can [something] make two connections and transfer data.

    just as you are seeing, the possibilities boil down to what you are familiar with: linked server, openrowset, SSIS, or the actual programming language of your choice.(ie vb.net/c#.net , for starters.)

    if you are talking about moving data changes regularly, you might want to consider built in SQL technologies like replication or logshipping; you can also do something with ipropagating by using CDC and reading the changes from there.

    If you are talking about dschema or data differences, tools like Redgates SQL Compare or Redgates SQL Data Compare might be an option.

    if you offer a bit more detail on what you are trying to accomplish, we can offer better suggestions.

    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!

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

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