+ Reply to Thread
Posts 1 to 4 of 4
  1. #1

    Still gathering requirements...


    Join Date
    Jun 2017
    Posts
    62
    Thanks (Given)
    3
    Thanks (Received)
    7
    Likes (Given)
    3
    Likes (Received)
    11

    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,359
    Thanks (Given)
    754
    Thanks (Received)
    741
    Likes (Given)
    4919
    Likes (Received)
    2853

    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
    Posts
    94,672
    Thanks (Given)
    18620
    Thanks (Received)
    4955
    Likes (Given)
    18620
    Likes (Received)
    8658

    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

    Contractor Among Contractors

    quackhandle's Avatar
    Join Date
    Mar 2010
    Location
    Bag End, The Shire, Middle Earth
    Posts
    1,982
    Thanks (Given)
    79
    Thanks (Received)
    70
    Likes (Given)
    746
    Likes (Received)
    316

    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.