We have SQL Server databases in every retail store, and one database in main office. We want to collect data from all stores and load the main DB (for BI), but we also want to sync data from main DB to retail DBs, when new product is awailable for selling.The solution has to provide reliable and scalable mechanism for data synchronization, using transactions, tracking the data that is not synced.I read about SSIS and tools, I was wondering if SSIS is good choice for this task.
MS SSIS as good approach for two-way data synchronization
sql server;business intelligence;ssis