Exports SQL Server replication articles

Export-SqlReplicationArticles .ps1

function Export-SqlReplicationArticles {
    [CmdletBinding()]
    param(
        [Parameter(Mandatory=$true)]
        [string]$ServerInstance,
        
        [Parameter(Mandatory=$true)]
        [string]$DatabaseName,
        
        [Parameter(Mandatory=$true)]
        [string]$OutputPath
    )
    
    Import-Module SqlServer
    
    # Check if server instance exists
    $serverExists = Test-Connection -ComputerName $ServerInstance -Count 1 -Quiet
    if (-not $serverExists) {
        Write-Error "Server instance '$ServerInstance' not found."
        return
    }
    
    # Check if database exists
    $databaseExists = Get-DbaDatabase -SqlInstance $ServerInstance -Database $DatabaseName -ErrorAction SilentlyContinue
    if (-not $databaseExists) {
        Write-Error "Database '$DatabaseName' not found on server instance '$ServerInstance'."
        return
    }
    
    $articles = Get-DbaReplicationArticle -SqlInstance $ServerInstance -Database $DatabaseName
    
    if ($articles.Count -eq 0) {
        Write-Warning "No replication articles found in database '$DatabaseName' on server instance '$ServerInstance'."
        return
    }
    
    $articles | Export-Csv -Path $OutputPath -NoTypeInformation
}