Share via

Is it possible to Sync OnPremise SQL data to Azure SQL with where condition on table using SQL Azure Data Sync?

Samir KHIMANI 21 Reputation points
2020-09-18T12:58:08.387+00:00

Hi,

I would like to sync On-premise SQL database tables to Azure SQL. In On-premise database, we are storing data for all clients in same database but I would like to sync client wise data to client specific Azure SQL database.

Is it possible using Azure Sync Agent?

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Julian Hüppauff 336 Reputation points Microsoft Employee
    2020-09-18T13:30:22.463+00:00

    Hi,

    Azure Data Sync is a "all in" service.
    You can opt-in certain tables.

    For your szenario you could use Azure Data Factory.
    This can copy data based on queries.

    0 comments