Powershell SQL Client SMO

preview_player
Показать описание
Using Powershell SMO you can run SQL Server statements and commands without the need to install more software.
This video shows how SQL Client SMO can be used with Powershell to select or create objects in SQL Server.

The example script for this can be found on Github.

Follow us on
Рекомендации по теме
Комментарии
Автор

This is great, I didnt know you could interact with SQL Server like that. All my scripts use combinations of invoke-sqlcmd and invoke-sqlcmd2. Can you replace those cmdlets with this method? It seems like you could? 🤔

FragrantVagrant