Add-DbaReplArticle View Source Jess Pomfret (@jpomfret), jesspomfret.com Windows, Linux, macOS 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.
Disable-DbaReplDistributor View Source Jess Pomfret (@jpomfret), jesspomfret.com Windows, Linux, macOS Synopsis Removes SQL Server replication distribution configuration from target instances.
Description Removes the distribution database and configuration from SQL Server instances currently acting as replication distributors. This command terminates active connections to distribution databases and uninstalls the distributor role completely. Use this when decommissioning replication, troubleshooting distribution issues, or reconfiguring your replication topology. The Force parameter allows removal even when dependent objects or remote publishers cannot be contacted.
Disable-DbaReplPublishing View Source Jess Pomfret (@jpomfret), jesspomfret.com Windows, Linux, macOS Synopsis Disables replication publishing on SQL Server instances and removes publisher configuration.
Description Removes the publisher role from SQL Server instances that are currently configured for replication publishing. This function safely dismantles the publishing configuration by removing the publisher from the distributor, which stops all publication activity on the target instance. Use this when decommissioning replication setups or troubleshooting publisher configuration issues that require a clean restart.
Enable-DbaReplDistributor View Source Jess Pomfret (@jpomfret), jesspomfret.com Windows, Linux, macOS Synopsis Configures a SQL Server instance as a replication distributor with distribution database
Description Configures the specified SQL Server instance to act as a replication distributor by creating the distribution database and installing the distributor role. This is the first step in setting up SQL Server replication, as the distributor manages the flow of replicated transactions between publishers and subscribers.
Enable-DbaReplPublishing View Source Jess Pomfret (@jpomfret), jesspomfret.com Windows, Linux, macOS Synopsis Configures a SQL Server instance as a replication publisher on an existing distributor.
Description Configures a SQL Server instance to publish data for replication by creating the necessary publisher configuration on an existing distributor. This is typically the second step in setting up SQL Server replication, after the distributor has been configured with Enable-DbaReplDistributor. The function sets up the snapshot working directory, configures publisher security authentication, and registers the instance as a publisher with the distribution database.
Export-DbaReplServerSetting View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Generates T-SQL scripts to recreate SQL Server replication distributor and publication configurations
Description Creates T-SQL scripts that can recreate your SQL Server replication setup, including distributor configuration, publications, subscriptions, and all related settings. The generated scripts include both creation commands and a distributor cleanup statement, making this perfect for disaster recovery planning, environment migrations, or replication topology documentation.
Get-DbaReplArticle View Source Cláudio Silva (@claudioessilva), claudioessilva.eu Windows, Linux, macOS Synopsis Retrieves detailed information about replication articles from SQL Server publications.
Description Retrieves comprehensive details about articles within SQL Server replication publications, helping DBAs audit and manage replication topology. Articles define which tables, views, or stored procedures are included in a publication for data distribution to subscribers.
This function examines all accessible databases on the specified instances and returns article properties including name, type, schema, source objects, and partitioning details.
Get-DbaReplArticleColumn View Source Cláudio Silva (@claudioessilva), claudioessilva.eu Windows, Linux, macOS Synopsis Retrieves column-level replication configuration details for SQL Server publication articles.
Description Returns detailed information about which columns are included in replication articles, helping DBAs audit replication configurations and troubleshoot column-specific replication issues. This is particularly useful when working with vertical partitioning scenarios where only specific columns from source tables are replicated to subscribers, or when investigating why certain columns aren’t appearing in replicated data.
Get-DbaReplDistributor View Source William Durkin (@sql_williamd) Windows, Linux, macOS Synopsis Retrieves replication distributor configuration and status information from SQL Server instances.
Description Connects to SQL Server instances and retrieves detailed information about their replication distributor configuration, including distributor status, distribution database details, and publisher relationships. This is essential for DBAs managing replication topologies who need to quickly identify which servers act as distributors, where the distribution database is located, and whether remote publishers are configured.
Get-DbaReplPublication View Source Colin Douglas Windows, Linux, macOS Synopsis Retrieves replication publications from SQL Server instances, including transactional, merge, and snapshot publications.
Description Scans SQL Server instances to identify and return all replication publications configured as publishers. This function examines each database’s replication options to locate published databases, then retrieves detailed information about their publications including associated articles and subscriptions. DBAs use this to audit replication topology, troubleshoot publication configuration issues, and document existing replication setup across their environment.
dbatools