can we sync only last two month data from hub DB to member DB having several years data?

anuj yadav 20 Reputation points
2023-05-03T16:01:45.4433333+00:00

can we sync only last two month data from Azure SQL data sync hub DB to member DB having several years data, i mean conditional sync?

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,073 questions
0 comments No comments
{count} votes

Accepted answer
  1. Alberto Morillo 33,176 Reputation points MVP
    2023-05-03T16:40:41.2+00:00

    You cannot filter rows or have a conditional sync using Azure SQL Data Sync. However, you can build a custom solution based on Sync Framework as explained here.

    You can also try a product named SymmetricDS. It supports Azure SQL Database and can filter rows (using routers of type lookup, sub-select, or BSH).

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful