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
    116
    Thanks (Given)
    3
    Thanks (Received)
    8
    Likes (Given)
    4
    Likes (Received)
    13

    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,384
    Thanks (Given)
    755
    Thanks (Received)
    742
    Likes (Given)
    4942
    Likes (Received)
    2860

    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
    Littering gel wrappers in Surrey
    Posts
    95,851
    Thanks (Given)
    20554
    Thanks (Received)
    5284
    Likes (Given)
    20554
    Likes (Received)
    9175

    Default

    Sounds link you need linked databases and proper indexes. Or Sybase....
    Katy Perry - don't be afraid to catch feels. Taylor Swift - feels $1 a go.

  4. #4

    Super poster

    quackhandle's Avatar
    Join Date
    Mar 2010
    Location
    Bag End, The Shire, Middle Earth
    Posts
    2,029
    Thanks (Given)
    82
    Thanks (Received)
    76
    Likes (Given)
    798
    Likes (Received)
    323

    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.