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-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.
Copy-DbaXESession View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Copies Extended Event sessions from one SQL Server instance to another, excluding system sessions.
Description Copies custom Extended Event sessions between SQL Server instances while preserving their configuration and running state. This function scripts out the session definitions from the source server and recreates them on the destination, making it essential for server migrations, standardizing monitoring across environments, or setting up disaster recovery instances.
Export-DbaBinaryFile View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Extracts binary data from SQL Server tables and writes it to physical files
Description Retrieves binary data stored in SQL Server tables and writes it as files to the filesystem. This is useful for extracting documents, images, or other files that have been stored in database columns using binary, varbinary, or image datatypes.
The function automatically detects filename and binary data columns based on column names and datatypes, but you can specify custom columns if needed.
dbatools