Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 221
  • Last Modified:

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

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

1 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.
carlosmonteAuthor Commented:
Thank you for your response.
I'm still talking to the software company and will have more questions soon
Thanks again

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now