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