1

I have a table on Azure SQL Database that I would like to have replicated/mirrored to our on-premise SQL Server

So the on-prem SQL Server would have a copy of table from Azure that is always up-to-date, available for read-only queries

Is there a technology for this ?

The reason I need this is because I need to join this Azure table to some tables on-premise (on 300K + rows) in a query, and linked server is not working for me very well, despite all the tricks and workarounds I have tried

Regards,

Improve this question

1 Answer 1

Reset to default
4

In theory, Azure Data Sync does this, but it's been in "preview" status for years, and there's a lot of gotchas. Read the documentation carefully to see if its limits can work for you, and just know that in a preview program, Microsoft can end up removing support for it later.

A better solution would be something like SSIS jobs to keep the data in sync, but that's obviously not easy, either. As your tables change, you'll need to keep changing the ETL jobs.

Improve this answer
1
  • Azure Data Sync is for 2 way syncing isn't it? I believe the OP is asking for mirroring/replication so isn't there a simpler way to do that?
    – akousmata
    Commented Apr 8, 2019 at 16:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.