Share via

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.
14,137 questions
0 comments
Accepted answer
  1. Alberto Morillo 34,146 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

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.