Invoke-DevartSyncDatabaseSchema

NAME Invoke-DevartSyncDatabaseSchema



SYNOPSIS

Comparing and synchronizing schema's.





SYNTAX

Invoke-DevartSyncDatabaseSchema -Source <object> -Target <object> [-FilterPath <string>] [-QueryBatchTimeout

<int>] [-Report <SwitchParameter>] [-ReportFilePath <string>] [-ReportFormat <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

Default value

Accept pipeline input? false

Accept wildcard characters? false



-Target <object>

Target schema to be updated.



Required? true

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-SynchronizationOptions <string>

Specifies the SQL 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

Default value

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

Default value

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

Default value

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

Default value False

Accept pipeline input? false

Accept wildcard characters? false



-ReportFilePath <string>

Path to the report file.



Required? false

Position? named

Default value

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



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).



INPUTS



OUTPUTS

System.Boolean





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



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





RELATED LINKS

See web documentation for a complete list of supported SynchronizationOptions.

http://docs.devart.com/schema-compare-f ... -line.html

Online help:

https://docs.devart.com/devops-automati ... chema.html