---
title: "Add-DbaReplArticle"
description: "Adds a table or other database object as an article to an existing replication publication."
url: "https://dbatools.io/Add-DbaReplArticle/"
availability: "Windows only"
tags: ["repl", "Replication"]
author: "Jess Pomfret (@jpomfret), jesspomfret.com"
source: "https://github.com/dataplat/dbatools/blob/master/public/Add-DbaReplArticle.ps1"
last_updated: "2024-01-01"
---

# Add-DbaReplArticle

## Synopsis

Adds a table or other database object as an article to an existing replication publication.

## Description

Adds a database object (typically a table) as an article to an existing SQL Server replication publication. Articles define which tables and data get replicated to subscribers. This function supports both transactional and merge replication publications, allowing you to expand replication topology without using SQL Server Management Studio. You can apply horizontal filters to replicate only specific rows, and customize schema options like indexes and statistics that get created on subscriber databases.

## Syntax

```powershell
Add-DbaReplArticle
    [-SqlInstance] <DbaInstanceParameter[]>
    [[-SqlCredential] <PSCredential>]
    [-Database] <String>
    [-Publication] <String>
    [[-Schema] <String>]
    [-Name] <String>
    [[-Filter] <String>]
    [[-CreationScriptOptions] <PSObject>]
    [-EnableException]
    [-WhatIf]
    [-Confirm]
    [<CommonParameters>]

```

## Examples

### Example 1: Adds the TableToRepl table to the PubFromPosh publication from mssql1.Northwind

```powershell
PS C:\> Add-DbaReplArticle -SqlInstance mssql1 -Database Northwind -Publication PubFromPosh -Name TableToRepl
```

### Example 2: Adds the publishers table to the TestPub publication from mssql1.Pubs with a horizontal filter of only rows...

```powershell
PS C:\> $article = @{
>> SqlInstance           = "mssql1"
>> Database              = "pubs"
>> Publication           = "testPub"
>> Name                  = "publishers"
>> Filter                = "city = 'seattle'"
>> }
PS C:\> Add-DbaReplArticle @article -EnableException
```

Adds the publishers table to the TestPub publication from mssql1.Pubs with a horizontal filter of only rows where city = 'seattle.  

### Example 3: Adds the stores table to the testPub publication from mssql1.pubs with the NonClusteredIndexes and Statistics...

```powershell
PS C:\> $cso = New-DbaReplCreationScriptOptions -Options NonClusteredIndexes, Statistics
PS C:\> $article = @{
>> SqlInstance           = 'mssql1'
>> Database              = 'pubs'
>> Publication           = 'testPub'
>> Name                  = 'stores'
>> CreationScriptOptions = $cso
>> }
PS C:\> Add-DbaReplArticle @article -EnableException
```

Adds the stores table to the testPub publication from mssql1.pubs with the NonClusteredIndexes and Statistics options set  
includes default options.  

### Required Parameters

##### -SqlInstance

The SQL Server instance(s) for the publication.

| Property | Value |
| --- | --- |
| Alias |  |
| Required | True |
| Pipeline | true (ByValue) |
| Default Value |  |

##### -Database

Specifies the database containing both the publication and the object you want to add as an article.  
This must be the same database where your replication publication was created.

| Property | Value |
| --- | --- |
| Alias |  |
| Required | True |
| Pipeline | false |
| Default Value |  |

##### -Publication

Specifies the name of the existing replication publication to add the article to.  
The publication must already exist and be configured for the type of replication you want (transactional, snapshot, or merge).

| Property | Value |
| --- | --- |
| Alias |  |
| Required | True |
| Pipeline | false |
| Default Value |  |

##### -Name

Specifies the name of the database object (typically a table) to add as an article to the publication.  
This object will be replicated to all subscribers of the publication.

| Property | Value |
| --- | --- |
| Alias |  |
| Required | True |
| Pipeline | false |
| Default Value |  |

### Optional Parameters

##### -SqlCredential

Login to the target instance using alternative credentials. Accepts PowerShell credentials (Get-Credential).  
Windows Authentication, SQL Server Authentication, Active Directory - Password, and Active Directory - Integrated are all supported.  
For MFA support, please use Connect-DbaInstance.

| Property | Value |
| --- | --- |
| Alias |  |
| Required | False |
| Pipeline | false |
| Default Value |  |

##### -Schema

Specifies the schema name of the object you want to add as an article.  
Use this when your table or object exists in a schema other than dbo. Defaults to dbo if not specified.

| Property | Value |
| --- | --- |
| Alias |  |
| Required | False |
| Pipeline | false |
| Default Value | dbo |

##### -Filter

Applies a WHERE clause condition to filter which rows get replicated from the article (horizontal filtering).  
Use this when you only want to replicate specific rows, such as "City = 'Seattle'" or "Status = 'Active'". Do not include the word 'WHERE' in your filter expression.

| Property | Value |
| --- | --- |
| Alias |  |
| Required | False |
| Pipeline | false |
| Default Value |  |

##### -CreationScriptOptions

Controls which schema elements get created on the subscriber database when the article is replicated.  
Use this to specify whether indexes, constraints, triggers, and other objects should be created on subscribers. Create this object using New-DbaReplCreationScriptOptions.

| Property | Value |
| --- | --- |
| Alias |  |
| Required | False |
| Pipeline | false |
| Default Value |  |

##### -EnableException

By default, when something goes wrong we try to catch it, interpret it and give you a friendly warning message.  
This avoids overwhelming you with "sea of red" exceptions, but is inconvenient because it basically disables advanced scripting.  
Using this switch turns this "nice by default" feature off and enables you to catch exceptions with your own try/catch.

| Property | Value |
| --- | --- |
| Alias |  |
| Required | False |
| Pipeline | false |
| Default Value | False |

##### -WhatIf

If this switch is enabled, no actions are performed but informational messages will be displayed that explain what would happen if the command were to run.

| Property | Value |
| --- | --- |
| Alias | wi |
| Required | False |
| Pipeline | false |
| Default Value |  |

##### -Confirm

If this switch is enabled, you will be prompted for confirmation before executing any operations that change state.

| Property | Value |
| --- | --- |
| Alias | cf |
| Required | False |
| Pipeline | false |
| Default Value |  |

## Outputs

**Microsoft.SqlServer.Replication.TransArticle or Microsoft.SqlServer.Replication.MergeArticle**

Returns one article object for each successfully added article. For transactional and snapshot replication, a TransArticle object is returned. For merge replication, a MergeArticle object is returned.

**Default display properties (via Select-DefaultView):**

- ComputerName: The name of the computer where the SQL Server instance is running
- InstanceName: The name of the SQL Server instance
- SqlInstance: The full SQL Server instance name (computer\instance)
- DatabaseName: The name of the database containing the article
- PublicationName: The name of the publication containing the article
- Name: The name of the article as it appears in the publication
- Type: The type of article (table, view, stored procedure, etc.)
- VerticalPartition: Boolean indicating if the article uses vertical partitioning (column filtering)
- SourceObjectOwner: The schema of the source object (typically 'dbo')
- SourceObjectName: The name of the source object being replicated

**Additional properties available (from SMO Article object):**

- BusinessLogicHandlerName: Name of the business logic handler (merge replication only)
- ColumnTrackingLevel: Column tracking level for merge replication
- CreationScript: Script containing the CREATE TABLE statement for the article
- DestinationObjectName: Optional different object name on the subscriber
- DestinationObjectOwner: Optional different schema name on the subscriber
- FilterClause: WHERE clause used for horizontal partitioning (row filtering)
- HorizontalPartition: Boolean indicating if the article uses horizontal partitioning
- IdentityRange: Range for identity column values (transactional replication only)
- IdentityRangeManagementOption: How identity ranges are managed
- IdentitySeed: Starting value for identity column replication
- PreCreatedObject: Boolean indicating if the object already exists on the subscriber
- PublicationName: Name of the publication containing the article
- SchemaOption: Defines which schema elements are included in the replication
All properties from the SMO Article object are accessible using Select-Object *.

---

Part of [dbatools](https://dbatools.io/), a free and open source PowerShell module for SQL Server administration. Full command index: https://dbatools.io/commands/