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

Please note that documentation and command names may be out of date while we work furiously towards 1.0


New-DbaSqlConnectionStringBuilder

Creates a System.Data.SqlClient.SqlConnectionStringBuilder from a connection string.

Screenshots

dbatools - New-DbaSqlConnectionStringBuilder

Examples

Returns an empty ConnectionStringBuilder.

New-DbaSqlConnectionStringBuilder

Returns a connection string builder that can be used to connect to the local sql server instance on the default port.

“Data Source=localhost,1433;Initial Catalog=AlwaysEncryptedSample;UID=sa;PWD=alwaysB3Encrypt1ng;Application Name=Always Encrypted Sample MVC App;Column Encryption Setting=enabled” | New-DbaSqlConnectionStringBuilder

Author

This command was created by zippy1981.

Get-Help

From PowerShell, execute Get-Help New-DbaSqlConnectionStringBuilder -Detailed for more information on this function.

Source Code

Want to see the source code? View New-DbaSqlConnectionStringBuilder.ps1 on GitHub
 

Related commands