-
Notifications
You must be signed in to change notification settings - Fork 0
Add VsCodeDatabaseConnection
external help file: Codesmithy-help.xml Module Name: Codesmithy online version: https://marketplace.visualstudio.com/items?itemName=ms-mssql.mssql schema: 2.0.0
Adds a VS Code MSSQL database connection to the repo.
Add-VsCodeDatabaseConnection [-ProfileName] <String> [-ServerInstance] <String> [-Database] <String>
[[-UserName] <String>] [-Force] [-ProgressAction <ActionPreference>] [<CommonParameters>]
The VSCode MSSQL extension can use saved database connections to connect to for queries, and this allows adding those to the VSCode settings in the current git repo.
Add-VsCodeDatabaseConnection ConnectionName ServerName\instance DatabaseName
Adds an MSSQL extension trusted connection named ConnectionName that connects to the server ServerName\instance and database DatabaseName.
The name of the connection.
Type: String
Parameter Sets: (All)
Aliases: Name
Required: True
Position: 1
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: FalseThe name of a server (and optional instance) to connect and use for the query.
Type: String
Parameter Sets: (All)
Aliases: Server, DataSource
Required: True
Position: 2
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: FalseThe the database to connect to on the server.
Type: String
Parameter Sets: (All)
Aliases: InitialCatalog
Required: True
Position: 3
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: FalseThe username to connect with. No password will be stored. If no username is given, a trusted connection will be created.
Type: String
Parameter Sets: (All)
Aliases: UID
Required: False
Position: 4
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: FalseOverwrite an existing profile with the same name.
Type: SwitchParameter
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: False{{ Fill ProgressAction Description }}
Type: ActionPreference
Parameter Sets: (All)
Aliases: proga
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseThis cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.
https://marketplace.visualstudio.com/items?itemName=ms-mssql.mssql