Class AstTransferSqlServerObjectsTaskNode
The Transfer SQL Server Objects task copies objects in a SQL Server database from on instance of SQL Server to another. The version of SQL Server being used determines what types of objects can be copied.
Namespace: Varigence.Languages.Biml.Task
Assembly: Biml.dll
C#
public class AstTransferSqlServerObjectsTaskNode : AstTaskBaseNode, IBindableItem, IGetJsonProvider, INamedNode, IScopeBoundary, IReferenceableItem, IFrameworkItem, IValidationInfo, INamedItem, IDataflowItem
Inheritance AstNode
-
Implements
Varigence.Utility.Collections.IVulcanCollectionParent, Varigence.Utility.ComponentModel.IVulcanNotifyPropertyChanged, Varigence.Utility.ComponentModel.IPropertyChangeNotificationTarget, System.ComponentModel.INotifyPropertyChanged, Varigence.Utility.Xml.IXObjectMappingProvider, System.ComponentModel.IDataErrorInfo, Varigence.Utility.Collections.IScopedNameIndexable,
Constructors
| Constructors | Description |
|---|---|
| AstTransferSqlServerObjectsTaskNode(IFrameworkItem) | Initializes a new instance of the AstTransferSqlServerObjectsTaskNode class with the specified parent node. |
Fields
| Fields | Description |
|---|---|
| ScopedNamePrefixBackingStore | |
| IsScopeImported |
Properties
| Properties | Description |
|---|---|
| CopyAllDefaults | This value specifies whether all SQL Server default objects are copied, or only those specified. |
| CopyAllDefaultsDefaultValue | Gets the default value for the CopyAllDefaults property |
| CopyAllDriObjects | This value specifies whether all declarative referential integrity (DRI) objects are copied, or only those specified. |
| CopyAllDriObjectsDefaultValue | Gets the default value for the CopyAllDriObjects property |
| CopyAllLogins | This value indicates whether all SQL Server logins are copied, or only those specified. |
| CopyAllLoginsDefaultValue | Gets the default value for the CopyAllLogins property |
| CopyAllObjects | This value indicates whether all SQL Server database objects are copied, or only those specified. |
| CopyAllObjectsDefaultValue | Gets the default value for the CopyAllObjects property |
| CopyAllPartitionFunctions | This value indicates whether all SQL Server partitions are copied, or only those specified. |
| CopyAllPartitionFunctionsDefaultValue | Gets the default value for the CopyAllPartitionFunctions property |
| CopyAllPartitionSchemes | This value indicates whether all SQL Server partition schemes are copies, or only those specified. |
| CopyAllPartitionSchemesDefaultValue | Gets the default value for the CopyAllPartitionSchemes property |
| CopyAllRules | This value indicates whether all SQL Server rules are copied, or only those specified. |
| CopyAllRulesDefaultValue | Gets the default value for the CopyAllRules property |
| CopyAllSchemas | This value indicates whether all SQL Server schemas are copied, or only those specified. |
| CopyAllSchemasDefaultValue | Gets the default value for the CopyAllSchemas property |
| CopyAllSqlAssemblies | This value indicates whether all SQL Server assemblies are copied, or only those specified. |
| CopyAllSqlAssembliesDefaultValue | Gets the default value for the CopyAllSqlAssemblies property |
| CopyAllStoredProcedures | This value indicates whether all SQL Server stored procedures are copied, or only those specified. |
| CopyAllStoredProceduresDefaultValue | Gets the default value for the CopyAllStoredProcedures property |
| CopyAllTables | This value indicates whether all SQL Server tables are copied, or only those indicated. |
| CopyAllTablesDefaultValue | Gets the default value for the CopyAllTables property |
| CopyAllUserDefinedAggregates | This value indicates whether all user-defined aggregates are transferred, or only those specified. |
| CopyAllUserDefinedAggregatesDefaultValue | Gets the default value for the CopyAllUserDefinedAggregates property |
| CopyAllUserDefinedDataTypes | This value indicates whether all user-defined data types are copied, or only those specified. |
| CopyAllUserDefinedDataTypesDefaultValue | Gets the default value for the CopyAllUserDefinedDataTypes property |
| CopyAllUserDefinedFunctions | This value indicates whether all user-defined functions are copied, or only those specified. |
| CopyAllUserDefinedFunctionsDefaultValue | Gets the default value for the CopyAllUserDefinedFunctions property |
| CopyAllUserDefinedTypes | This value indicates whether all user-defined types are copied, or only those specified. |
| CopyAllUserDefinedTypesDefaultValue | Gets the default value for the CopyAllUserDefinedTypes property |
| CopyAllUsers | This value indicates whether all SQL Server database users are copied, or only those specified. |
| CopyAllUsersDefaultValue | Gets the default value for the CopyAllUsers property |
| CopyAllViews | This value indicates whether all SQL Server views are copied, or only those specified. |
| CopyAllViewsDefaultValue | Gets the default value for the CopyAllViews property |
| CopyAllXmlSchemaCollections | This value indicates whether all XML schema collections are copied, or only those specified. |
| CopyAllXmlSchemaCollectionsDefaultValue | Gets the default value for the CopyAllXmlSchemaCollections property |
| CopyData | This value specifies whether data is included when tables and views are copied. |
| CopyDatabaseRoles | This value specifies whether database roles are copied. |
| CopyDatabaseRolesDefaultValue | Gets the default value for the CopyDatabaseRoles property |
| CopyDatabaseUsers | This value specifies whether database users are copied. |
| CopyDatabaseUsersDefaultValue | Gets the default value for the CopyDatabaseUsers property |
| CopyDataDefaultValue | Gets the default value for the CopyData property |
| CopyForeignKeys | This value specifies whether foreign keys are copied. |
| CopyForeignKeysDefaultValue | Gets the default value for the CopyForeignKeys property |
| CopyFullTextIndexes | This value specifies whether full-text properties are copied. |
| CopyFullTextIndexesDefaultValue | Gets the default value for the CopyFullTextIndexes property |
| CopyIndexes | This value specifies whether indexes are copied. |
| CopyIndexesDefaultValue | Gets the default value for the CopyIndexes property |
| CopyObjectLevelPermissions | This value specifies whether indexes are copied. |
| CopyObjectLevelPermissionsDefaultValue | Gets the default value for the CopyObjectLevelPermissions property |
| CopyPrimaryKeys | This value specifies whether indexes are copied. |
| CopyPrimaryKeysDefaultValue | Gets the default value for the CopyPrimaryKeys property |
| CopySchema | This value specifies whether the schema is copied. |
| CopySchemaDefaultValue | Gets the default value for the CopySchema property |
| CopySqlServerLogins | This value specifies whether SQL Server logins are copied. |
| CopySqlServerLoginsDefaultValue | Gets the default value for the CopySqlServerLogins property |
| CopyTriggers | This value specifies whether triggers are copied. |
| CopyTriggersDefaultValue | Gets the default value for the CopyTriggers property |
| Defaults | This is a collection of the names of default objects to be copied when the value of CopyAllDefaults is set to False. |
| DefaultsDefaultValue | Gets the default value for the Defaults property |
| DestinationConnection | This value specifies the SQL Server Management Objects (SMO) connection for the destination database. |
| DestinationDatabase | This value specifies the name of the destination database to use. |
| DestinationDatabaseDefaultValue | Gets the default value for the DestinationDatabase property |
| DestinationTranslateChar | This value specifies whether AutoTranslate will be used to minimize problems with the transfer of character data when the source and the destination have different code pages. |
| DestinationTranslateCharDefaultValue | Gets the default value for the DestinationTranslateChar property |
| DropObjectsFirst | This value specifies whether objects selected for transfer are removed from the destination before the transfer begins. |
| DropObjectsFirstDefaultValue | Gets the default value for the DropObjectsFirst property |
| ExistingData | This value specifies whether data copied from the source overwrites existing data in the destination database or is appended to the existing data. |
| ExistingDataDefaultValue | Gets the default value for the ExistingData property |
| FriendlyTypeNameStatic | Gets the friendly name of the type of this node |
| GenerateScriptsInUnicode | This value specifies whether data copied from the source overwrites existing data in the destination database or is appended to the existing data. |
| GenerateScriptsInUnicodeDefaultValue | Gets the default value for the GenerateScriptsInUnicode property |
| IncludeDependentObjects | This value specifies whether dependent objects are copied. |
| IncludeDependentObjectsDefaultValue | Gets the default value for the IncludeDependentObjects property |
| IncludeExtendedProperties | This value specifies whether extended properties are copied. |
| IncludeExtendedPropertiesDefaultValue | Gets the default value for the IncludeExtendedProperties property |
| Logins | This is a collection of the SQL Server logins that are to be copied when the value of CopyAllLogins is set to False. |
| LoginsDefaultValue | Gets the default value for the Logins property |
| PartitionFunctions | This is a collection of the partition functions that are to be copied when the value of CopyAllPartitionFunctions is set to False. |
| PartitionFunctionsDefaultValue | Gets the default value for the PartitionFunctions property |
| PartitionSchemes | This is a collection of the partition schemes that are to be copied when the value of CopyAllPartitionSchemes is set to False. |
| PartitionSchemesDefaultValue | Gets the default value for the PartitionSchemes property |
| Rules | This is a collection of the rules that are to be copied when the value of CopyAllRules is set to False. |
| RulesDefaultValue | Gets the default value for the Rules property |
| Schemas | This is a collection of the schemas that are to be copied when the value of CopyAllSchemas is set to False. |
| SchemasDefaultValue | Gets the default value for the Schemas property |
| SourceConnection | This value specifies the SQL Server Management Objects (SMO) connection for the source database. |
| SourceDatabase | This value specifies the name of the database from which objects will be copied. |
| SourceDatabaseDefaultValue | Gets the default value for the SourceDatabase property |
| SourceTranslateChar | This value specifies whether AutoTranslate will be used to minimize problems with the transfer of character data when the source and the destination have different code pages. |
| SourceTranslateCharDefaultValue | Gets the default value for the SourceTranslateChar property |
| SqlAssemblies | This is a collection of the SQL Server assemblies that are to be copied when the value of CopyAllSqlAssemblies is set to False. |
| SqlAssembliesDefaultValue | Gets the default value for the SqlAssemblies property |
| StoredProcedures | This is a collection of the stored procedures that are to be copied when the value of CopyAllStoredProcedures is set to False. |
| StoredProceduresDefaultValue | Gets the default value for the StoredProcedures property |
| Tables | This is a collection of the tables that are to be copied when the value of CopyAllTables is set to False. |
| TablesDefaultValue | Gets the default value for the Tables property |
| UseCollation | This value specifies whether collation settings are maintained during the transfer. Performance may decrease if UseCollation is set to True and the data includes non-Unicode data types such as text or varchar, or if the source database contains a large number of tables, columns, and rows. The default value is false. |
| UseCollationDefaultValue | Gets the default value for the UseCollation property |
| UserDefinedAggregates | This is a collection of the user-defined aggregates that are to be copied when the value of CopyAllUserDefinedAggregates is set to False. |
| UserDefinedAggregatesDefaultValue | Gets the default value for the UserDefinedAggregates property |
| UserDefinedDataTypes | This is a collection of the user-defined data types that are to be copied when the value of CopyAllUserDefinedDataTypes is set to False. |
| UserDefinedDataTypesDefaultValue | Gets the default value for the UserDefinedDataTypes property |
| UserDefinedFunctions | This is a collection of the user-defined functions that are to be copied when the value of CopyAllUserDefinedFunctions is set to False. |
| UserDefinedFunctionsDefaultValue | Gets the default value for the UserDefinedFunctions property |
| UserDefinedTypes | This is a collection of the user-defined types that are to be copied when the value of CopyAllUserDefinedTypes is set to False. |
| UserDefinedTypesDefaultValue | Gets the default value for the UserDefinedTypes property |
| Users | This is a collection of the SQL Server database users that are to be copied when the value of CopyAllUsers is set to False. |
| UsersDefaultValue | Gets the default value for the Users property |
| Views | This is a collection of the views that are to be copied when the value of CopyAllViews is set to False. |
| ViewsDefaultValue | Gets the default value for the Views property |
| XmlSchemaCollections | This is a collection of the XML schema collections that are to be copied when the value of CopyAllXmlSchemaCollections is set to False. |
| XmlSchemaCollectionsDefaultValue | Gets the default value for the XmlSchemaCollections property |
| ExecutionValueVariable | Specifies a variable to hold the execution results of this component. |
| VisibleVariables | Gets a collection of all variable nodes that are available to be used by this task. It includes variables defined by this task and any tasks/packages that contain this task |
| VisiblePackageParameters | Gets a collection of all package parameter nodes that are available to be used by this task. |
| VisibleProjectParameters | Gets a collection of all project parameter nodes that are available to be used by this task. This include all parameters defined by all package projects that contain the parent package for this task. |
| OutputPath | Gets a default OutputPath that all subsequent nodes will connect to, if they choose to create a precendence constraint |
| SystemVariables | Gets a collection of all variables defined in this task that have been provided by SSIS as system variables |
| PrecedenceConstraints | This is a container for task precedence constraint definitions. |
| Events | This is a collection of event handlers that can respond to SQL Server Integration Services events that are raised on this task. |
| DelayValidation | This value specifies whether the validation of the Dataflow task in SSIS should be delayed until the package is executed. DelayValidation is most often used when the ETL process references tables and other server assets that were created in an earlier stage of the data processing run. |
| IsolationLevel | Sets the Isolation Level which controls how Transactions behave for this container. |
| ForcedExecutionValue | If the ForceExecutionValue property is set to True, then the container will return the value stored in this property as its execution value. Otherwise, this value will be ignored. The default value for ForecedExecutionValue is 0. |
| ForceExecutionResult | This value indicates whether a specified execution result value will result if the container runs. The default value is None, which means that the container does not force a specified outcome. |
| ForceExecutionValue | Gets or sets a Boolean that indicates whether the execution value of the container should be forced to contain the value specified in the ForcedExecutionValue property. |
| ForcedExecutionValueDataType | This property specifies the data type of the value stored in the ForceExecutionValue property. |
| Disabled | This value specifies whether the item is disabled. The default value is False. |
| FailPackageOnFailure | This value determines whether the container will fail when a container component fails. If this container corresponds to a package, then the only valid value is False. |
| FailParentOnFailure | This value determines whether the parent container will fail when a child container failes. The default value is False. |
| MaximumErrorCount | This value specifies the maximum number of errors allowed to occur before a package is forced to stop running. The default value is 1. |
| Language | This specifies the default language to be used by this task and its descendants. |
| DisableEventHandlers | This value specifies whether the event handlers for this task, container, or package should be prevented from executing. The default value is False. |
| TransactionMode | This value specifies the transaction context in which this task will execute. |
| Variables | This is a container for variable definitions that are specific to this task, container, or package. |
| LoggingMode | This value specifies whether logging is enabled or disabled by the container or by the parent container. The default value is UseParentSetting. |
| LogEvents | This is a container for log event definitions that are specific to this task, container, or package. |
| LogProviders | Defines the log providers to use for the SSIS task or container |
| Expressions | This is a collection of SSIS expression definitions for property value overrides that are specific to this task, container, or package. |
| Id | Allows the developer to specify a unique identifier (GUID) for the package. This can be used to retain a consistent ID between builds. |
| DelayValidationDefaultValue | Gets the default value for the DelayValidation property |
| IsolationLevelDefaultValue | Gets the default value for the IsolationLevel property |
| ForcedExecutionValueDefaultValue | Gets the default value for the ForcedExecutionValue property |
| ForceExecutionResultDefaultValue | Gets the default value for the ForceExecutionResult property |
| ForceExecutionValueDefaultValue | Gets the default value for the ForceExecutionValue property |
| DisabledDefaultValue | Gets the default value for the Disabled property |
| FailPackageOnFailureDefaultValue | Gets the default value for the FailPackageOnFailure property |
| FailParentOnFailureDefaultValue | Gets the default value for the FailParentOnFailure property |
| MaximumErrorCountDefaultValue | Gets the default value for the MaximumErrorCount property |
| LanguageDefaultValue | Gets the default value for the Language property |
| DisableEventHandlersDefaultValue | Gets the default value for the DisableEventHandlers property |
| TransactionModeDefaultValue | Gets the default value for the TransactionMode property |
| LoggingModeDefaultValue | Gets the default value for the LoggingMode property |
| IdDefaultValue | Gets the default value for the Id property |
| ScopedName | Gets the scoped name which can be used to uniquely identify this object among other objects of its type |
| SymbolTable | Gets a reference to the symbol table that stores a reference to this and all other named objects in the project |
| SsisSafeScopedName | Returns a version of the ScopedName that has been cleaned of invalid characters for SSIS. |
| SsisSafeName | Returns a version of the Name that has been cleaned of invalid characters for SSIS. |
| Name | Specifies the name of the object. This name can be used to reference this object from anywhere else in the program. |
| References | Gets collection of FrameworkItemReference objects, which track rich information about the properties that hold references to this node. |
| NameDefaultValue | Gets the default value for the Name property |
| Guid | |
| Annotations | This is a collection of annotation items that can be used to specify documentation, tags, or other information. Annotations are particularly useful for storing information about nodes that can be used by BimlScript code. |
| ObjectTag | This property provides a general purpose storage mechanism for .NET objects to be associated with AstNode objects. It supplements the annotation system, which is intended for use with string-based metadata. |
| BimlFile | This value specifies the BimlFile in which the Biml code that defines AstNode resides. |
| ItemLabel | Gets a label that can be used to identify this node |
| ParentItem | This value specifies the parent of the current node. All nodes must have a valid parent in the Biml framework, except for the root node. |
Methods
| Methods | Description |
|---|---|
| BindingScopeBoundaries() | Retrieves the permitted scope boundaries to bind references from this node. |
| Duplicate() | Creates a duplicate of the current node |
| Duplicate(IFrameworkItem) | Creates a duplicate of the current node with the specified parent item |
| GetAllItemsReferencedByDefinedSuccessors() | Builds a list of all items referenced by this node and its successors. Each tuple in the returned list represents a FrameworkItemReference. The first item is the ReferencingItem, the second item is the property name, and the third item is the ReferencedItem. |
| GetDefaultValue(String) | Retrieves the default value for the property with the name propertyName |
| GetDefaultValue<T>(String) | Retrieves the default value for the property with the name propertyName |
| StructureEquals(Object) | Compares this node to the provided object to determine if all defined children and references are equal. |
| AddExpressionProperty(AstPropertyNode) | |
| CreateVariable(String, String, String, Boolean, Boolean, IncludeInDebugDump, TypeCode, Object) | Adds a variable with this task as the parent node |
| AddVariable(String, String, String, Boolean, Boolean, IncludeInDebugDump, TypeCode, Object) | Adds a variable with this task as the parent node |
| DefinedAstNodes() | Retrieves a collection of nodes that have been defined as direct children of the current node. |
| GetSchemaLocalName() | Retrieves the local XML element name that corresponds to this node in Biml code. |
| ToString() | Returns a string that represents the current object. In this case, it is the Name of the node. |
| OnScopedNameChanged(String, String) | |
| OnItemLabelChanged(String, String) | |
| OnNameChanging(String, String) | |
| OnNameChanged(String, String) | |
| AddScopedNameChangedEventListener(IReferenceableItem, EventHandler<VulcanPropertyChangedEventArgs>) | Adds the scoped name changed event handler to the specified referenceable item. |
| RemoveScopedNameChangedEventListener(IReferenceableItem, EventHandler<VulcanPropertyChangedEventArgs>) | Removes the scoped name changed event handler from the specified referenceable item. |
| FirstChildOfType<TChild>() | Gets the first defined descendant node of the specified type |
| RemoveFromParent() | Removes this node definition from its parent |
| GetJson() | Generates a JavaScript Object Notation (JSON) representation of the current node |
| GetExternalJson() | Generates a JavaScript Object Notation (JSON) representation of the current node |
| GetJson(Boolean, Boolean, Boolean, Boolean, Boolean) | Generates a JavaScript Object Notation (JSON) representation of the current node |
| GetXObjectName() | Gets the fully qualified XML element name for this node in the code document. |
| FirstParent<TAstNode>() | Retrieves the first parent or ancestor node of the specified type |
| FirstParent<TAstNode>(Type) | Retrieves the first parent or ancestor node of the specified type with the specified custom attribute type |
| FirstThisOrParent<TAstNode>() | Retrieves the first parent or ancestor node of the specified type, including this node |
| IsDirectAncestor(IFrameworkItem) | Retrieves a value indicating whether the specified node is a direct ancestor of this node. |
| AncestorDistance(IFrameworkItem) | Retrieves the number of steps between this node and the nearest shared ancestor with the specified relative node. |
| FirstThisOrParent<TAstNode>(Type) | Retrieves the first parent or ancestor node (including this node) of the specified type with the specified custom attribute type |
| AllDefinedSuccessors() | Retrieves the collection of all nodes defined as a child of this or any successor node or the current node |
| AllDefinedSuccessors(Boolean) | Retrieves the collection of all nodes defined as a child of this or any successor node or optionally the current node |
| OnNotificationTargetPropertyChanged(String) | |
| OnScopeBoundaryChanged(IScopeBoundary, IScopeBoundary) | |
| AddParseableChangedEventListener(IFlowFileChanged, EventHandler<EventArgs>) | |
| RemoveParseableChangedEventListener(IFlowFileChanged, EventHandler<EventArgs>) | |
| AddScopeBoundaryChangedEventListener(IFrameworkItem, EventHandler<VulcanPropertyChangedEventArgs>) | |
| RemoveScopeBoundaryChangedEventListener(IFrameworkItem, EventHandler<VulcanPropertyChangedEventArgs>) | |
| AddParsePendingChangedEventListener(IFlowFileChanged, EventHandler<EventArgs>) | |
| RemoveParsePendingChangedEventListener(IFlowFileChanged, EventHandler<EventArgs>) | |
| AddFromTemplateChangedEventListener(IFlowFileChanged, EventHandler<EventArgs>) | |
| RemoveFromTemplateChangedEventListener(IFlowFileChanged, EventHandler<EventArgs>) | |
| ParseSelf(XElement, ParserContext) | |
| ParseNameValueMapping(XElement) |