Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How can I connect data between on premises SQL Server and SQL Azure Database?

April 26, 2017azure Connect Data database premises sql SQL Server

0

Posted

How can I connect data between on premises SQL Server and SQL Azure Database?

1 Answer

0

Posted

The management too provided for SQL Azure Data Sync will walk you through the steps of selecting the database and tables you wish to synchronize and then create a SQL Agent task to automatically synchronize the data with SQL Azure based on a periodic schedule. This can be useful in scenarios where for instance you want to create a Web App in Windows Azure and connect that Web App to on premises data sources for reporting or other purposes.