Link to home
Start Free TrialLog in
Avatar of carlosmonte
carlosmonteFlag for United States of America

asked on

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

CRM
ASKER CERTIFIED SOLUTION
Avatar of Zberteoc
Zberteoc
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of carlosmonte

ASKER

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