With the constant shift in technology at full speed how does a client deal with data and systems that are proprietary or can only be run on local servers? In the past, the only recourse was to spin up a full server in the cloud and replicate the data to another database instance. The tools did not exist within Azure to move sites to a serverless infrastructure. Over the last few years, Azure has matured and what was impossible has become a viable and exciting new option. Moving your data to the cloud and using the power of Azure is an excellent option.
One of RSI’s clients had an on-site accounting system that did not have the flexibility to move to the cloud. To make their data available online, RSI was able to use SQL Data and File Sync to set up a read only copy of their inventory to allow clients to order products online. Using an API locally we can also accept the data back into the source accounting system. File sync allows us to make available safety and data information on products as well that are designed and reviewed onsite to allow compliance and information to their clients.
Azure SQL Data Sync allows you to sync data multi-directionally to multiple databases both locally and in the cloud.
To learn more about the tool, see the link below:
https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-data-sql-server-sql-database?view=azuresql
One caveat is if you have a database with over 500 tables the system will not function. But with a little creative magic we found you can create a restricted user that only views the tables needed for syncing or to split the tables across multiple databases if all the tables are needed. Add DENY permissions to the tables to go around the challenge.
Azure File Sync allows a company to centralize your local file shares into Azure and make them available to use in Azure.
To learn more about the tool, see the link below:
https://learn.microsoft.com/en-us/azure/storage/file-sync/file-sync-introduction
