dbatools is a free PowerShell module with over 180 SQL Server administration, best practice and migration commands included.


This command copies ALL user objects (tables, stored procs, functions, etc) in ALL system databases, hence the pluralized command name. This is useful for DBA’s who keep their maintenance tasks in system databases, and for the model database.


From PowerShell, execute Get-Help Copy-SqlSysDbUserObjects -Detailed for more information on this function.

Source Code

Want to see the source code? View Copy-SqlSysDbUserObjects.ps1 on GitHub

Related commands