Post reply

Upsert operation between servers

  • July 17, 2019 at 12:51 pm

    #3663722

    Hello Everyone,

    We need to perform UpSert operation between multiple tables belongs to different server , can you please suggest any Technical design for this.

    Suppose a consultant made some changes in UAT  at some point of time then later he wants to migrate same in Production.

    It may be a new records , updated record .

     

    Thanks 🙂

    • This topic was modified 4 years, 9 months ago by  Abhi kr.
    • This topic was modified 4 years, 9 months ago by  Abhi kr.

  • July 17, 2019 at 9:54 pm

    #3663930

    There are numerous ways to send make changes on another server from a different server. Linked servers, openrowset, etc.

    However, if you are making changes in UAT, save those scripts. Someone should not run some new script on production. There also is no reason to run a query from a UAT/test server to a prod server. You would be better to separate changes, either moving the data or writing queries that contain the data.

  • July 18, 2019 at 12:26 am

    #3663963

    Also take in consideration that if the non prod servers have a "free" SQL License on that UAT server  e.g. developer edition or MSDN licensed editions  then whatever data is on those servers can not be moved/copied up to a production environment as per license terms

  • July 29, 2019 at 7:26 am

    #3666696

    Thank You Everyone,

    Can we have add Hash-byte on column for only insert operation but on update operation.

    Could you please suggest.

    • This reply was modified 4 years, 9 months ago by  Abhi kr.
    • This reply was modified 4 years, 8 months ago by  Abhi kr.

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

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