TransferBase Class
Represents the base class for transfer.
Assembly: Microsoft.SqlServer.SmoExtended (in Microsoft.SqlServer.SmoExtended.dll)
Microsoft.SqlServer.Management.Smo::TransferBase
Microsoft.SqlServer.Management.Smo::DataTransferBase
| Name | Description | |
|---|---|---|
![]() | TransferBase() | Initializes a new instance of the TransferBase class. |
![]() | TransferBase(Database^) | Initializes a new instance of the TransferBase class that uses the specified database as the source of the transfer operation. |
| Name | Description | |
|---|---|---|
![]() | CopyAllDatabaseTriggers | Gets or sets a value that indicates whether all the SQL Server database triggers are copied from the source database to the target database in the transfer operation. |
![]() | CopyAllDefaults | Gets or sets a value that indicates whether all the SQL Server defaults are copied from the source database to the target database in the transfer operation. |
![]() | CopyAllFullTextCatalogs | Gets or sets a value that indicates whether all the SQL Server full-text catalogs are copied from the source database to the target database in the transfer operation. |
![]() | CopyAllFullTextStopLists | Gets or sets a value that indicates whether all the SQL Server full-text stop lists are copied from the source database to the target database in the transfer operation. |
![]() | CopyAllLogins | Gets or sets a value that indicates whether all the SQL Server logins are copied from the source database to the target database in the transfer operation. |
![]() | CopyAllObjects | Gets or sets a value that indicates whether all the SQL Server objects are copied from the source database to the target database in the transfer operation. |
![]() | CopyAllPartitionFunctions | Gets or sets a value that indicates whether all the SQL Server partition functions are copied from the source database to the target database in the transfer operation. |
![]() | CopyAllPartitionSchemes | Gets or sets a value that indicates whether all the SQL Server partition schemes are copied from the source database to the target database in the transfer operation. |
![]() | CopyAllPlanGuides | Gets or sets a value that indicates whether all the SQL Server plan guides are copied from the source database to the target database in the transfer operation. |
![]() | CopyAllRoles | Gets or sets a value that indicates whether all the SQL Server roles are copied from the source database to the target database in the transfer operation. |
![]() | CopyAllRules | Gets or sets a value that indicates whether all the SQL Server rules are copied from the source database to the target database in the transfer operation. |
![]() | CopyAllSchemas | Gets or sets a value that indicates whether all the SQL Server schemas are copied from the source database to the target database in the transfer operation. |
![]() | CopyAllSearchPropertyLists | Gets or sets a value that indicates whether all the SQL Server search property lists are copied from the source database to the target database in the transfer operation. |
![]() | CopyAllSequences | Gets or sets a value that indicates whether all the SQL Server sequences are copied from the source database to the target database in the transfer operation. |
![]() | CopyAllSqlAssemblies | Gets or sets a value that indicates whether all the SQL Server assemblies are copied from the source database to the target database in the transfer operation. |
![]() | CopyAllStoredProcedures | Gets or sets a value that indicates whether all the SQL Server stored procedures are copied from the source database to the target database in the transfer operation. |
![]() | CopyAllSynonyms | Gets or sets a value that indicates whether all the SQL Server synonyms are copied from the source database to the target database in the transfer operation. |
![]() | CopyAllTables | Gets or sets a value that indicates whether all the SQL Server tables are copied from the source database to the target database in the transfer operation. |
![]() | CopyAllUserDefinedAggregates | Gets or sets a value that indicates whether all the SQL Server user-defined aggregates are copied from the source database to the target database in the transfer operation. |
![]() | CopyAllUserDefinedDataTypes | Gets or sets a value that indicates whether all the SQL Server user-defined data types are copied from the source database to the target database in the transfer operation. |
![]() | CopyAllUserDefinedFunctions | Gets or sets a value that indicates whether all the SQL Server user-defined functions are copied from the source database to the target database in the transfer operation. |
![]() | CopyAllUserDefinedTableTypes | Gets or sets a value that indicates whether all the SQL Server user-defined table types are copied from the source database to the target database in the transfer operation. |
![]() | CopyAllUserDefinedTypes | Gets or sets a value that indicates whether all the SQL Server user-defined types are copied from the source database to the target database in the transfer operation. |
![]() | CopyAllUsers | Gets or sets a value that indicates whether all the SQL Server database users are copied from the source database to the target database in the transfer operation. |
![]() | CopyAllViews | Gets or sets a value that indicates whether all the SQL Server views are copied from the source database to the target database in the transfer operation. |
![]() | CopyAllXmlSchemaCollections | Gets or sets a value that indicates whether all the SQL Server XML schema collections are copied from the source database to the target database in the transfer operation. |
![]() | CopyData | Gets or sets a value that indicates whether all the data is copied from the source database to the target database in the transfer operation. |
![]() | CopySchema | Gets or sets a value that indicates whether the schema is copied from the source database to the target database in the transfer operation. |
![]() | CreateTargetDatabase | Gets or sets a value that indicates whether the target database is created in the transfer operation. |
![]() | Database | Gets or sets the database from which schema or data is to be transferred to the target location. |
![]() | DatabaseFileMappings | Gets or sets the properties that are associated with flat file destination based on a dictionary. |
![]() | DestinationDatabase | Gets or sets the database that is the destination of the transfer operation. |
![]() | DestinationLogin | Gets or sets the logon for the instance of SQL Server to which the destination database belongs. |
![]() | DestinationLoginSecure | Gets or sets a value that indicates whether the instance of SQL Server that contains the destination database is enabled for Windows Authentication or not. |
![]() | DestinationPassword | Gets or sets the logon password for the instance of SQL Server to which the destination database belongs. |
![]() | DestinationServer | Gets or sets the instance of SQL Server that owns the database that is the destination of the transfer operation. |
![]() | DestinationTranslateChar | Gets or sets a value that indicates whether the transfer operation translates the code page for characters on the destination database. |
![]() | DropDestinationObjectsFirst | Gets or sets a value that indicates whether to drop the objects in the destination database before the transfer operation. |
![]() | ObjectList | Gets or sets the objects copied from the source to destination in the transfer operation. |
![]() | Options | Gets or sets the options for the transfer operation. |
![]() | PrefetchObjects | Gets or sets a value that indicates whether to prefetch the objects before the transfer operation. |
![]() | PreserveDbo | Gets or sets a value that indicates whether DBO ownerships are retained through the transfer process. |
![]() | PreserveLogins | Gets or sets a value that indicates whether to preserve logins in the transfer operation. |
![]() | Scripter | Gets the scripter for the transfer operation. |
![]() | SourceTranslateChar | Gets or sets a value that indicates whether the transfer operation translates the code page for characters on the source database. |
![]() | TargetDatabaseFilePath | Gets or sets the path to where the database files will be copied. |
![]() | TargetLogFilePath | Gets or sets the path to where the log files will be copied. |
![]() | UseDestinationTransaction | Gets or sets a value that indicates whether to use the destination transaction. |
| Name | Description | |
|---|---|---|
![]() | EnumObjects() | Returns an enumerated list of Uniform Resource Name (URN) values that represent the objects included in the transfer operation. |
![]() | EnumScriptTransfer() | Creates a Transact-SQL command batch script used to transfer database objects or database objects and data to another database instance. |
![]() | Equals(Object^) | (Inherited from Object.) |
![]() | Finalize() | (Inherited from Object.) |
![]() | GetHashCode() | (Inherited from Object.) |
![]() | GetType() | (Inherited from Object.) |
![]() | MemberwiseClone() | (Inherited from Object.) |
![]() | ScriptTransfer() | Creates a Transact-SQL command batch script that creates database objects that are transferred by the transfer operation. |
![]() | SetTargetServerInfo() | Sets the target server version based on the SQL Server version. |
![]() | ToString() | (Inherited from Object.) |
| Name | Description | |
|---|---|---|
![]() | DiscoveryProgress | Marks the progress of the discovery process. |
![]() | ScriptingError | Reports that an error occurred during the scripting process. |
![]() | ScriptingProgress | Marks the progress of the scripting process. |
Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.




