Genpact Cora Knowledge Center

Support

PowerShell Function: Install-CoraSeQuenceArchiveDatabase

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. Standard format, including instance name and port if not default

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)