How do I create a distribution database in SQL Server?

Question

13 сент. 2021 г. · Узнайте, как настроить публикацию и распространение в SQL Server с помощью SQL . Create a new distribution database using the defaults, .Перед началом · Использование среды SQL.

How do you create a distribution database in SQL?

To configure distribution1In Microsoft SQL Server Management Studio, connect to the server that will be the Distributor (in many cases, the Publisher and Distributor are the same server), and then expand the server node.2Right-click the Replication folder, and then click Configure Distribution.

What is distribution database in SQL Server?

The distribution database stores metadata and history data for all types of replication, and transactions for transactional replication. In many cases, a single distribution database is sufficient. However, if multiple Publishers use a single Distributor, consider creating a distribution database for each Publisher.

Does SQL Server support distributed database?

Relational databases are therefore also known as SQL databases. However, the original SQL databases like Oracle, PostgreSQL, and MySQL are monolithic from an architectural standpoint. They are unable to distribute data and queries across multiple instances automatically.

Expert · Answer