Merging data between two SQL servers
+ Reply to Thread
Posts 1 to 4 of 4
  1. #1

    Should post faster


    Join Date
    Jun 2017
    Posts
    144
    Thanks (Given)
    3
    Thanks (Received)
    9
    Likes (Given)
    4
    Likes (Received)
    21

    Default Merging data between two SQL servers

    I've got a dilemma, one SQL server has all information I need, but is too slow to create intermediary tables, another is fast enough to create the intermediary tables, but is missing the data needed for the final step, all tables are too big for me to put on my local machine, and the connection between rstudio/SAS to SQL servers is out of maintenance at my company, anyone ever had a problem like this they have resolved before?

  2. #2

    Double Godlike!


    Join Date
    Dec 2012
    Posts
    10,832
    Thanks (Given)
    827
    Thanks (Received)
    830
    Likes (Given)
    5267
    Likes (Received)
    3059

    Default

    Couldn't you use a database link, to move the data where you created the intermediary tables?

    It won't perform very well though.

  3. #3

    TripleIronDad

    BrilloPad's Avatar
    Join Date
    Aug 2006
    Location
    Divorce Courts
    Posts
    98,185
    Thanks (Given)
    23272
    Thanks (Received)
    6081
    Likes (Given)
    23272
    Likes (Received)
    10311

    Default

    Sounds link you need linked databases and proper indexes. Or Sybase....
    I keep pushing forwards but they keep pushing me backwards. So I have new rules. 1. Don't feed the trolls you know they have no souls. 2. Don't respond to them they'll only post back back again. 3. Don't be their friend they'll only knife you in the back. I have new rules I count them.

  4. #4

    Super poster

    quackhandle's Avatar
    Join Date
    Mar 2010
    Location
    Bag End, The Shire, Middle Earth
    Posts
    2,091
    Thanks (Given)
    101
    Thanks (Received)
    91
    Likes (Given)
    893
    Likes (Received)
    347

    Default

    Many ways to skin a cat: Bulk insert (set recovery model to BULK LOGGED), bcp, SSIS package (might be too slow). backup, copy, restore.

    qh
    He had a negative bluety on a quackhandle and was quadraspazzed on a lifeglug.

+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Content Relevant URLs by vBSEO 3.6.0 ©2011, Crawlability, Inc.