Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Azure SQL Managed Instance
This section includes information on the replication dialog boxes that are available in Microsoft SQL Server Management Studio.
Agent security
These dialog boxes configure security settings for the replication agents that transfer data between publishers and subscribers.
| Dialog box | Description |
|---|---|
| Snapshot agent security | Configure security for the account under that runs the snapshot agent makes connections. |
| Log reader agent security | Configure security settings for the log reader agent that reads the transaction log. |
| Distribution agent security | Configure security for the account that runs the distribution agent and connects to subscribers. |
| Merge agent security | Configure security for the merge agent that synchronizes data in merge replication. |
| Queue reader agent security | Configure the queue reader agent for queued updating subscriptions. |
Agent profiles
These dialog boxes manage agent profiles that control replication agent behavior and performance.
| Dialog box | Description |
|---|---|
| Agent profiles (single agent) | View and modify profiles for a single replication agent. |
| Agent profiles | Manage all replication agent profiles on the Distributor. |
| <AgentProfileName> properties | View and modify the properties of a specific agent profile. |
| New agent profile | Create a new replication agent profile with custom parameters. |
Subscription validation
These dialog boxes validate that subscriber data matches publisher data to ensure replication consistency.
| Dialog box | Description |
|---|---|
| Validate all subscriptions | Validate data for all subscriptions to a publication. |
| Validate subscriptions | Select multiple subscriptions to validate at once. |
| Validate subscription | Validate a single subscription's data against the publisher. |
| Subscription validation options (Transactional subscriptions) | Configure row count or checksum validation options for transactional replication. |
| Subscription validation options (Merge subscriptions) | Configure validation options specific to merge replication subscriptions. |
Subscription reinitialization
These dialog boxes reinitialize subscriptions with a new snapshot when data resynchronization is required.
| Dialog box | Description |
|---|---|
| Reinitialize subscription(s) - all subscriptions | Reinitialize all subscriptions to a publication with a new snapshot. |
| Reinitialize subscription(s) - one subscription | Reinitialize a single subscription with a new snapshot. |
Scripting and connectivity
These dialog boxes generate replication scripts and configure connections to Oracle publishers.
| Dialog box | Description |
|---|---|
| Generate SQL script (replication objects) | Generate Transact-SQL scripts for creating and dropping replication objects. |
| Connect to server (Oracle), login | Enter login credentials to connect to an Oracle Publisher. |
| Connect to server (Oracle), connection properties | Configure connection properties such as timeout values for Oracle connections. |