A RetroSearch Logo

Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Search Query:

Showing content from https://learn.microsoft.com/en-us/azure/azure-sql/database/replication-to-sql-database below:

Replication to Azure SQL Database - Azure SQL Database

Applies to: Azure SQL Database SQL database in Fabric

You can configure Azure SQL Database or Fabric SQL database as the push subscriber in a one-way transactional or snapshot replication topology from SQL Server and Azure SQL Managed Instance.

Note

This article describes the use of transactional replication to push data to Azure SQL Database or Fabric SQL database. This article applies equally to Azure SQL Database and Fabric SQL database unless otherwise noted.

It's unrelated to active geo-replication, an Azure SQL Database feature that allows you to create complete readable replicas of individual databases.

Supported configurations Versions

To successfully replicate to a database in Azure SQL Database, SQL Server publishers and distributors must be using (at least) one of the following versions:

Note

Attempting to configure replication using an unsupported version can result in error number MSSQL_REPL20084 (The process could not connect to Subscriber.) and MSSQL_REPL40532 (Cannot open server <name> requested by the login. The login failed.).

To use all the features of Azure SQL Database, you must be using the latest versions of SQL Server Management Studio (SSMS) and SQL Server Data Tools.

Publishing to any Azure SQL Database from a SQL Server database is supported by the following versions of SQL Server:

Publishing to Fabric SQL database from a SQL Server database is supported by the following versions of SQL Server:

Types of replication

There are different types of replication:

Replication Architecture

Scenarios Typical Replication Scenario
  1. Create a transactional replication publication on a SQL Server database.
  2. On SQL Server use the New Subscription Wizard or Transact-SQL statements to create a push to subscription to Azure SQL Database.
  3. With single and pooled databases in Azure SQL Database, the initial data set is a snapshot that is created by the Snapshot Agent and distributed and applied by the Distribution Agent. With a SQL Managed Instance publisher, you can also use a database backup to seed the Azure SQL Database subscriber.
Data migration scenario
  1. Use transactional replication to replicate data from a SQL Server database to Azure SQL Database.
  2. Redirect the client or middle-tier applications to update the database copy.
  3. Stop updating the SQL Server version of the table and remove the publication.
Limitations

The following replication options aren't supported by Azure SQL Database:

Limitations to be determined Examples

Create a publication and a push subscription. For more information, see:

See Also

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4