We have a SQL Server which runs on a machine in our office with a database and tables which get written to daily.
Due to some business requirements we need some of these tables replicated on to a database on Azure. There will be not too many rows, only some hundred / thousand rows per day.
I have several ways to do this:
Create a job in our application which gets the data from the local SQL Server and writes it to the Azure DB via Entity Framework
SQL Server Replication (could this be used?)
Stretch Database (unfortunately not possible because some of the tables can't be stretched apperently..)
Linked server in the Azure-DB with a view that selects our local DB? (is this possible?)
Did you have such requirements before and what did you use to solve this?
What different option would you suggest?
Thanks in advance :-)
- SQL Server v13.0.4435.0
- Microsoft SQL Server Standard (64-bit) Edition