Genpact Cora Knowledge Center

Support

PowerShell Function: Install-CoraSeQuenceArchiveDatabase

V9.5

Module

CoraSeQuence.Database

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

CoraSeQuence.Database

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)