We have a local SQL database and I have been trying to use MS db sync on a few tables so we can consume data in our web application and API's from Salesforce via the Azure db - mainly for scalability and bandwidth. DB Sync is not working because some of our tables have clustered primary keys and the values in the clustered columns can change, so sync thinks a new record has been created instead of being changed.
What other options are there? Someone suggested a data warehouse as it doesn't rely on primary keys. What about table storage? All suggestions welcome.
Thanks,
Paul.
