V9.5
Module
Description
Deploys a Cora SeQuence archive database package.
NOTE
Run this function to deploy Cora SeQuence archive databases only.
Syntax
Install-CoraSeQuenceArchiveDatabase [-DatabasePackagePath] <String> [-SQLServer] <String> [-Database] <String> [[-SQLCredentials] <PSCredential>] [[-Credentials] <PSCredential>] [-Diagnostics] [[-Parameters] <Hashtable>] [[-Properties] <Hashtable>]
[<CommonParameters>]Parameters
-DatabasePackagePath <String>
The path to the archive database package.
| Required? | true |
| Position? | 1 |
| Default value | |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
-SQLServer <String>
The name of the SQL server used for hosting the Cora SeQuence archive database.
SQL server setup should follow Microsoft SQL standards and, include instance name and port.
| Required? | true |
| Position? | 2 |
| Default value | |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
-Database <String>
Determines the name of the deployed archive database.
| Required? | true |
| Position? | 3 |
| Default value | |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
-SQLCredentials <PSCredential>
The credentials to be used to connect to the SQL server, if needed. If not provided, the current user credentials are used with Windows Authentication.
| Required? | false |
| Position? | 4 |
| Default value | |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
-Credentials <PSCredential>
Credentials used to access DatabasePackagePath, if needed.
| Required? | false |
| Position? | 5 |
| Default value | |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
-Diagnostics [<SwitchParameter>]
Enables diagnostics for the database deployment. After deployment, a log file is created in the same location of the deployment files, under a temporary folder.
| Required? | false |
| Position? | named |
| Default value | False |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
-Parameters <Hashtable>
Adds additional parameters to the sqlpackage as specified here.
| Required? | false |
| Position? | 6 |
| Default value | |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
-Properties <Hashtable>
Adds additional properties to the sqlpackage as specified here.
| Required? | false |
| Position? | 7 |
| Default value | |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
<CommonParameters>
This function supports these common parameters: Verbose, Debug, ErrorAction, ErrorVariable, WarningAction, WarningVariable, OutBuffer, PipelineVariable, and OutVariable.
For more information, see about_CommonParameters.
Examples
With credentials:
PS C:\>Install-CoraSeQuenceArchiveDatabase -DatabasePackagePath "C:\PNMsoft.Sequence.SqlDatabase.Archiving_9.4.0.0.dacpac" -SQLServer "MySQLServer" -Database "CoraSeQuenceArchive" -SQLCredentials (Get-Credential)
V9.4
Module
Description
Deploys a Cora SeQuence archive database package.
NOTE
Run this function to deploy Cora SeQuence archive databases only.
Syntax
Install-CoraSeQuenceArchiveDatabase [-DatabasePackagePath] <String> [-SQLServer] <String> [-Database] <String> [[-SQLCredentials] <PSCredential>] [[-Credentials] <PSCredential>] [-Diagnostics] [<CommonParameters>]
Parameters
-DatabasePackagePath <String>
The path to the archive database package.
| Required? | true |
| Position? | 1 |
| Default value | |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
-SQLServer <String>
The name of the SQL server used for hosting the Cora SeQuence archive database.
SQL server setup should follow Microsoft SQL standards and, include instance name and port.
| Required? | true |
| Position? | 2 |
| Default value | |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
-Database <String>
Determines the name of the deployed archive database.
| Required? | true |
| Position? | 3 |
| Default value | |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
-SQLCredentials <PSCredential>
The credentials to be used to connect to the SQL server, if needed. If not provided, the current user is used with Windows Authentication.
| Required? | false |
| Position? | 4 |
| Default value | |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
-Credentials <PSCredential>
The credentials to be used to access DatabasePackagePath, if needed.
| Required? | false |
| Position? | 5 |
| Default value | |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
-Diagnostics [<SwitchParameter>]
Enables diagnostics for the database deployment. After deployment, a log file is created in the same location of the deployment files, under a temporary folder.
| Required? | false |
| Position? | named |
| Default value | False |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
<CommonParameters>
This function supports these common parameters: Verbose, Debug, ErrorAction, ErrorVariable, WarningAction, WarningVariable, OutBuffer, PipelineVariable, and OutVariable.
For more information, see about_CommonParameters.
Examples
With credentials:
PS C:\>Install-CoraSeQuenceArchiveDatabase -DatabasePackagePath "C:\PNMsoft.Sequence.SqlDatabase.Archiving_9.4.0.0.dacpac" -SQLServer "MySQLServer" -Database "CoraSeQuenceArchive" -SQLCredentials (Get-Credential)
