Post reply

Stored Procedures Local vs. Cloud

  • May 20, 2015 at 5:45 pm

    #398486

    Is there a way using a stored procedure in a local database to add a record to a database executing in a cloud environment when both entities reside in different domains?

  • May 20, 2015 at 7:05 pm

    #1799522

    Search for "Linked Servers" and "Openquery".

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • May 27, 2015 at 12:12 am

    #1800755

    A SQLCLR object that makes a connection to the Cloud database is an option as well. Given the "different domains" comment I suspect any connection between the two instances will need to be done using a SQL Server Login Name and Password and not rely on a Windows Security Context.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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