Subscribe replication from remote DB server if we have read-only access to it through SQL Management Studio

Posted on 2012-09-14
Last Modified: 2013-07-01
Hi Experts,

We are clients of a SaaS software. So our data is hosted on their servers.
We are discussing how we can get a coopy or connect to our data to build in-house applications.
The option that they are giving us is to give us access to their data servers with read only access to the DBs and access it through SQL management studio.

Now my question is how we can replicate that data from their servers into ours when i only have read access to it?
As i understand replication needs to have write access to both publisher and subscriber. in this case we only have read access in what would be the publisher.

Is this the right approach im taking?

What would you do in my case? what would be your approach

Thank you

Question by:carlosmonte
    LVL 26

    Accepted Solution

    You can have transactional replication from SaaS database to your local server. In this case you can do whatever you want with the database at your hand, or you can use it to backup and restore it on other servers in order to do changes so that the one replicated stays intact and as a permanent replica of the source. If you use replication like this you don't even need access to SaaS production environment, except to allow replication in one way.
    LVL 1

    Author Comment

    Thank you for your response.
    I'm still talking to the software company and will have more questions soon
    Thanks again

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now