SQL Release

Import-DlmDatabaseRelease

Import-DlmDatabaseRelease

Imports a DatabaseRelease object, exported to disk by Export-DlmDatabaseRelease, from a folder or .zip file.

Syntax

Import-DlmDatabaseRelease [-Path] <string> [<CommonParameters>]

Description

The Import-DlmDatabaseRelease cmdlet re-imports the database deployment resources that have been exported to a folder or .zip file by the Export-DlmDatabaseRelease cmdlet.

The DatabaseRelease object produced can then be used by the Use-DlmDatabaseRelease cmdlet to deploy the update.

Parameters

-Path <System.String>

The path to the folder or .zip file you want to import.

Aliases None
Required?true
Position?0
Default Value None
Accept Pipeline Inputfalse
Accept Wildcard Charactersfalse

<CommonParameters>

This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see http://technet.microsoft.com/en-us/library/hh847884.aspx.

Inputs

The input type is the type of the objects that you can pipe to the cmdlet.

  • None.
    You cannot pipe input to this cmdlet.

Return values

The output type is the type of the objects that the cmdlet emits.

  • RedGate.SQLRelease.Compare.Domain.DatabaseRelease

Examples

---------- EXAMPLE 1 ----------

$release = Import-DlmDatabaseRelease -Path "C:\DatabaseDeploymentResources"

This example shows how to import a folder to create the database deployment resources.

The Import-DlmDatabaseRelease cmdlet imports the folder C:\DatabaseDeploymentResources, creating the database deployment resources. This folder was created by exporting to C:\DatabaseDeploymentResources using the Export-DlmDatabaseRelease cmdlet.

Using Export-DlmDatabaseRelease and Import-DlmDatabaseRelease like this allows you to review the update script before you deploy with SQL Release.

---------- EXAMPLE 2 ----------

$release = Import-DlmDatabaseRelease -Path "C:\DatabaseDeploymentResources.zip"

This example shows how to import a .zip file to create the database deployment resources.

The Import-DlmDatabaseRelease cmdlet imports the .zip file C:\DatabaseDeploymentResources.zip, creating the database deployment resources.


Didn't find what you were looking for?