Description

Add a new public command Set-SqlDscDatabaseDefaultFullTextCatalog to configure the default full-text catalog for a SQL Server database using the SMO SetDefaultFullTextCatalog() method.

Details

The DefaultFullTextCatalog property on the SMO Database class requires calling the SetDefaultFullTextCatalog() method rather than direct property assignment. This command should be implemented as a separate cmdlet following the pattern established by other method-based commands.

Proposed Implementation

• Command Name: Set-SqlDscDatabaseDefaultFullTextCatalog
• Parameter Sets:
  • ServerObject + Name (with optional Refresh)
  • DatabaseObject (accepting pipeline input)
• Required Parameters:
  • CatalogName: The name of the full-text catalog to set as default
• Optional Parameters:
  • Force: Bypass confirmation prompts
  • PassThru: Return the updated database object
• Behavior:
  • Support ShouldProcess for -WhatIf and -Confirm
  • Call $databaseObject.SetDefaultFullTextCatalog($CatalogName) on the SMO Database object
  • Include proper parameter validation and error handling
  • Follow DSC Community PowerShell coding guidelines

Related Issues and PRs

• Related to issue Set-SqlDscDatabase: Add parameters to command #2177 (Expose settable SMO Database properties)
• Discovered in PR Set-SqlDscDatabaseProperty: Refactor command #2327 (Set-SqlDscDatabase refactoring)
• Comment: Set-SqlDscDatabaseProperty: Refactor command #2327 (comment)

References

• SMO Documentation: Database.SetDefaultFullTextCatalog Method