Copy-DbaLinkedServer View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Migrates linked servers and their authentication credentials from one SQL Server instance to another
Description Migrates SQL Server linked servers including all authentication credentials and connection settings from a source instance to one or more destination instances. The function preserves usernames and passwords by using password decryption techniques, eliminating the need to manually recreate linked server configurations and re-enter sensitive credentials.
Copy-DbaLogin View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Copies SQL Server logins between instances with passwords, permissions, and role memberships intact
Description Transfers SQL Server logins from one instance to another while preserving authentication details and security context. Essential for server migrations, disaster recovery setups, and environment synchronization where you need users to maintain the same access without recreating accounts manually.
Handles both SQL Server and Windows Authentication logins, copying passwords (with original SIDs to prevent orphaned users), server roles, database permissions, and login properties like password policy enforcement.
Copy-DbaPolicyManagement View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Copies Policy-Based Management policies, conditions, and categories between SQL Server instances
Description Transfers your entire Policy-Based Management framework from one SQL Server instance to another, including custom policies, conditions, and categories. This streamlines environment standardization and disaster recovery scenarios where you need identical compliance policies across multiple servers.
By default, all non-system policies and conditions are copied. Existing objects on the destination are skipped unless -Force is used to overwrite them.
Copy-DbaRegServer View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Copies Central Management Server groups and registered server instances between SQL Server instances.
Description Migrates registered servers and server groups from a source Central Management Server to a destination CMS, preserving the hierarchical structure of groups and subgroups. This eliminates the need to manually recreate complex server organization structures when setting up new environments or consolidating server management. The function handles conflicts by either skipping existing items or dropping and recreating them when Force is specified.
Copy-DbaResourceGovernor View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Copies SQL Server Resource Governor configuration including pools, workload groups, and classifier functions between instances
Description Migrates your entire SQL Server Resource Governor setup from one instance to another, including custom resource pools, workload groups, and classifier functions. This saves you from manually recreating complex Resource Governor configurations when setting up new servers or during migrations.
The function copies all non-system resource pools (excludes the built-in “internal” and “default” pools) along with their associated workload groups and settings.
Copy-DbaServerRole View Source the dbatools team + Claude Windows, Linux, macOS Synopsis Migrates custom server roles and their permissions between SQL Server instances
Description Copies user-defined server roles from the source server to one or more destination servers. This is essential when migrating SQL Server instances that use custom server roles for granular permission management, or when standardizing security configurations across multiple environments.
Only custom (user-defined) server roles are copied by default.
Copy-DbaSpConfigure View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Copies SQL Server configuration settings (sp_configure values) from source to destination instances.
Description This function retrieves all sp_configure settings from the source SQL Server and applies them to one or more destination instances, ensuring consistent configuration across your environment. Only settings that differ between source and destination are updated, making it safe for standardizing existing servers. The function automatically handles settings that require a restart and provides detailed reporting of which configurations were changed, skipped, or failed.
Copy-DbaSsisCatalog View Source Phil Schwartz (philschwartz.me, @pschwartzzz) Windows, Linux, macOS Synopsis Migrates SSIS catalogs including folders, projects, and environments between SQL Server instances.
Description Copies the complete SSISDB catalog structure from a source SQL Server to one or more destination instances. This function handles server migrations, environment promotions, and disaster recovery scenarios where you need to replicate your Integration Services deployments.
By default, all folders, projects, and environments are copied.
Copy-DbaStartupProcedure View Source Shawn Melton (@wsmelton), wsmelton.github.io Windows, Linux, macOS Synopsis Copies startup procedures from master database between SQL Server instances
Description Migrates user-defined startup procedures stored in the master database from source to destination SQL Server instances. Startup procedures are stored procedures that automatically execute when SQL Server starts up, commonly used for server initialization tasks, custom monitoring setup, or configuration validation.
This function identifies procedures flagged with the startup option using sp_procoption, copies their definitions to the destination master database, and configures them as startup procedures.
Copy-DbaSystemDbUserObject View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Copies user-created objects from system databases (master, msdb, model) between SQL Server instances.
Description Migrates custom database objects that DBAs commonly store in system databases like maintenance procedures, monitoring tables, custom triggers, and backup utilities from master and msdb. Also transfers objects from the model database that will be included in new databases created on the destination instance.
dbatools