An Azure SQL database is a database-as-a-service offering from Microsoft Azure. An Azure SQL database can be configured as a subscriber to an on-premises SQL Server publisher. This is one of best methods to use for migrating an on-premises database to an Azure SQL database. Moreover, the Azure SQL database subscriber can also be used as a backup or to offload reads from the publisher.
To configure Azure SQL database as a subscriber for an on-premises transactional replication, follow these steps:
Note
Open a new PowerShell console (running as administrator) and execute the Install-Module AzureRm command to install the AzureRm PowerShell module. The AzureRm module is a prerequisite for this exercise.
The first step is to create a new blank Azure SQL database. Open a new PowerShell console window and execute the following...