| Author | Jess Pomfret (@jpomfret), jesspomfret.com |
| Availability | Windows, Linux, macOS |
Want to see the source code for this command? Check out New-DbaReplSubscription on GitHub.
Want to see the Bill Of Health for this command? Check out New-DbaReplSubscription.
Creates a subscription for the database on the target SQL instances.
Creates a subscription for the database on the target SQL instances.
New-DbaReplSubscription
[-SqlInstance] <DbaInstanceParameter>
[[-SqlCredential] <PSCredential>]
[[-Database] <String>]
[-SubscriberSqlInstance] <DbaInstanceParameter[]>
[[-SubscriberSqlCredential] <PSCredential>]
[[-SubscriptionDatabase] <String>]
[-PublicationName] <String>
[[-SubscriptionSqlCredential] <PSCredential>]
[-Type] <String>
[-EnableException]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
PS C:\> New-DbaReplSubscription -SqlInstance sql2017 -Database pubs -SubscriberSqlInstance sql2019 -SubscriptionDatabase pubs -PublicationName testPub -Type Push
Creates a push subscription from sql2017 to sql2019 for the pubs database.
PS C:\> New-DbaReplSubscription -SqlInstance sql2017 -Database pubs -SubscriberSqlInstance sql2019 -SubscriptionDatabase pubs -PublicationName testPub -Type Pull
Creates a pull subscription from sql2017 to sql2019 for the pubs database.
The target publishing SQL Server instance or instances.
| Alias | |
| Required | True |
| Pipeline | true (ByValue) |
| Default Value |
The subscriber SQL instance.
| Alias | |
| Required | True |
| Pipeline | false |
| Default Value |
The name of the replication publication
| Alias | |
| Required | True |
| Pipeline | false |
| Default Value |
The flavour of the subscription. Push or Pull.
| Alias | |
| Required | True |
| Pipeline | false |
| Default Value | |
| Accepted Values | Push,Pull |
Login to the target publishing 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.
| Alias | |
| Required | False |
| Pipeline | false |
| Default Value |
The database on the publisher that will be replicated.
| Alias | |
| Required | False |
| Pipeline | false |
| Default Value |
Login to the subscriber 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.
| Alias | |
| Required | False |
| Pipeline | false |
| Default Value |
The database on the subscriber that will be the target of the replicated data.
| Alias | |
| Required | False |
| Pipeline | false |
| Default Value |
Credential object that will be saved as the 'subscriber credential' in the subscription properties.
| Alias | |
| Required | False |
| Pipeline | false |
| Default Value |
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.
| Alias | |
| Required | False |
| Pipeline | false |
| Default Value | False |
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.
| Alias | wi |
| Required | False |
| Pipeline | false |
| Default Value |
If this switch is enabled, you will be prompted for confirmation before executing any operations that change state.
| Alias | cf |
| Required | False |
| Pipeline | false |
| Default Value |