Invoke-DevartSyncDatabaseSchema

Synopsis

Comparing and synchronizing schemas.

Syntax:

Invoke-DevartSyncDatabaseSchema -Source <object> -Target <object> [-QueryBatchTimeout <int>] [-Report <SwitchParameter>] [-ReportFilePath <string>] [-ReportFormat <string>]
[-ReportGroupBy <string>] [-SynchronizationOptions <string>] [-TransactionIsolationLevel <string>] [<CommonParameters>]

Description:

Returns false if synchronization failed; otherwise true.

Parameters:

-Source <object>

Source to connect to a live database or loads database objects from the specified scripts folder or NuGet package.

Required? true

Position? named

Accept pipeline input? false

Accept wildcard characters? false

-Target <object>

Target schema to be updated.

Required? true

Position? named

Accept pipeline input? false

Accept wildcard characters? false

-SynchronizationOptions <string>

Specifies the Schema Compare options used during creation of the script for synchronization.

To include additional options, specify a slash-separated list of the options.

For example: /IgnoreCase:Yes /IgnorePrimaryKeys:No

See related links for more detailed information about options.

Required? false

Position? named

Accept pipeline input? false

Accept wildcard characters? false

-TransactionIsolationLevel <string>

Use this parameter to specify the isolation level for the transactions during the temporary deployment for validation.

Permitted values are: Serializable, Snapshot, RepeatableRead, ReadCommitted and ReadUncommitted. The default level is Serializable.

Required? false

Position? named

Accept pipeline input? false

Accept wildcard characters? false

-QueryBatchTimeout <int>

Parameter is applied for each of the expressions in a synchronization script. This parameter will be ignored if the Target is not an object of the DevartDatabaseConnectionInfo.

Required? false

Position? named

Default value 30

Accept pipeline input? false

Accept wildcard characters? false

-Report <SwitchParameter>

Use this parameter to generate schema comparison report.

Required? false

Position? named

Accept pipeline input? false

Accept wildcard characters? false

-ReportFilePath <string>

Path to the report file.

Required? false

Position? named

Accept pipeline input? false

Accept wildcard characters? false

-ReportFormat <string>

Specify the format of the comparison report.

Required? false

Position? named

Default value Html

Accept pipeline input? false

Accept wildcard characters? false

-ReportGroupBy <string>

Group objects in comparison report.

Required? false

Position? named

Default value Status

Accept pipeline input? false

Accept wildcard characters? false

-FilterPath <string>

Use this parameter to specify a filter file to be used when performing the sync operation.

Required? false

Position? named

Accept pipeline input? false

Accept wildcard characters? false

<CommonParameters>

This cmdlet supports the following common parameters: Verbose, Debug, ErrorAction, ErrorVariable, WarningAction, WarningVariable, OutBuffer, PipelineVariable, and OutVariable. For more information, see About CommonParameters.

Outputs:

System.Boolean (returns true on success and false otherwise)

Examples:

---------- EXAMPLE 1 ----------
$syncResult = Invoke-DevartSyncDatabaseSchema -Source $connection -Target $targetConnection

See web documentation for a complete list of the supported SynchronizationOptions.