xSQL Schema Compare SDK for SQL Server version 12
ScriptManager Class Members
Properties  Methods  Events


The following tables list the members exposed by ScriptManager.

Public Properties
 NameDescription
Public PropertyEnableContraintScriptsGets the collection of script fragments that enable foreign keys and check constraints. If the option ComparisonOptions.ScriptConstraintsWithNoCheck is selected.  
Public PropertyOptions Gets the comparison option.  
Public PropertyPostTransactionScripts Gets the collection of script fragments that run after the main transaction.  
Public PropertyPreTransactionScripts Gets the collection of script fragments that run before the main transaction.  
Public PropertySourceDatabase Gets the source database.  
Public PropertyTargetDatabase Gets the target database.  
Public PropertyTransactionalScripts Gets the collection of script fragments that run within the main transaction.  
Top
Public Methods
 NameDescription
Public MethodExecuteOverloaded.  Executes the synchronization script against the default target database.  
Public MethodExecuteEnableConstraintsOverloaded.  Executes the script that enables the foreign keys and check constraints that were created with NOCHECK option by the main synchronization script.  
Public MethodGetEnableConstraintsLog Returns the log associated with the script that enables foreign keys or check constraints.  
Public MethodGetEnableConstraintsScriptOverloaded.  Returns the script that enables the foreign keys or check constraints.  
Public MethodGetLog Returns the synchronization log which indicates the objects that are modified by the synchronization script.  
Public MethodGetScriptOverloaded.  Returns the schema synchronization script for the default target database.  
Public MethodGetWarnings Returns any warnings associated with the schema synchronization script.  
Public MethodHasEnableConstraintsScript Indicates whether this object contains script fragments that enable the foreign keys or check constraints.  
Public MethodHasWarnings Indicates whether the synchronization script has any warnings.  
Public MethodIsEmpty Returns true if the synchronization script is empty.  
Top
Public Events
 NameDescription
Public EventExecutionCanceled Occurs when the execution of synchronization script is canceled.  
Public EventExecutionFailed Occurs when the execution of synchronization script fails.  
Public EventExecutionProgress Occurs during the script execution and provides progress information such as the percentage of the overall script that has been completed.  
Public EventExecutionStarting Occurs before the execution of synchronization script starts.  
Public EventExecutionSucceeded Occurs after the execution of synchronization script succeeds.  
Public EventSchemaOperation Occurs during scripting or execution and provide progress information.  
Public EventSchemaScriptExecuted Occurs after a script fragment executes.  
Public EventSchemaScriptExecuting Occurs before a script fragment executes.  
Top
Public Operators
public Operator Addition Appends two ScriptManager object together.
Top
See Also

Reference

ScriptManager Class
xSQL.SchemaCompare.SqlServer Namespace

 

 


©Copyright 2022 xSQL Software. All Rights Reserved.

Send Feedback