carlosmonte
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I'm still talking to the software company and will have more questions soon
Thanks again