Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Transfer Properties

The Transfer type exposes the following members.

  NameDescription
Public property CopyAllDatabaseTriggers Gets or sets the Boolean property value that specifies whether all the SQL Server database triggers are copied from the source database to the target database in the transfer operation.
Public property CopyAllDefaults Gets or sets the Boolean property value that specifies whether all the SQL Server defaults are copied from the source database to the target database in the transfer operation.
Public property CopyAllFullTextCatalogs Gets or sets the Boolean property value that specifies whether all the SQL Server Full-Text catalogs are copied from the source database to the target database in the transfer operation.
Public property CopyAllFullTextStopLists Gets or sets the Boolean property value that specifies whether all the SQL Server full-text stop lists are copied from the source database to the target database in the transfer operation.
Public property CopyAllLogins Gets or sets the Boolean property value that specifies whether all the SQL Server logins are copied from the source database to the target database in the transfer operation.
Public property CopyAllObjects Gets or sets the Boolean property value that specifies whether all the SQL Server objects are copied from the source database to the target database in the transfer operation.
Public property CopyAllPartitionFunctions Gets or sets the Boolean property value that specifies whether all the SQL Server partition functions are copied from the source database to the target database in the transfer operation.
Public property CopyAllPartitionSchemes Gets or sets the Boolean property value that specifies whether all the SQL Server partition schemes are copied from the source database to the target database in the transfer operation.
Public property CopyAllPlanGuides Gets or sets the Boolean property value that specifies whether all the SQL Server plan guides are copied from the source database to the target database in the transfer operation.
Public property CopyAllRoles Gets or sets the Boolean property value that specifies whether all the SQL Server roles are copied from the source database to the target database in the transfer operation.
Public property CopyAllRules Gets or sets the Boolean property value that specifies whether all the SQL Server rules are copied from the source database to the target database in the transfer operation.
Public property CopyAllSchemas Gets or sets the Boolean property value that specifies whether all the SQL Server schemas are copied from the source database to the target database in the transfer operation.
Public property CopyAllSqlAssemblies Gets or sets the Boolean property value that specifies whether all the SQL Server assemblies are copied from the source database to the target database in the transfer operation.
Public property CopyAllStoredProcedures Gets or sets the Boolean property value that specifies whether all the SQL Server stored procedures are copied from the source database to the target database in the transfer operation.
Public property CopyAllSynonyms Gets or sets the Boolean property value that specifies whether all the SQL Server synonyms are copied from the source database to the target database in the transfer operation.
Public property CopyAllTables Gets or sets the Boolean property value that specifies whether all the SQL Server tables are copied from the source database to the target database in the transfer operation.
Public property CopyAllUserDefinedAggregates Gets or sets the Boolean property value that specifies whether all the SQL Server user-defined aggregates are copied from the source database to the target database in the transfer operation.
Public property CopyAllUserDefinedDataTypes Gets or sets the Boolean property value that specifies whether all the SQL Server user-defined data types are copied from the source database to the target database in the transfer operation.
Public property CopyAllUserDefinedFunctions Gets or sets the Boolean property value that specifies whether all the SQL Server user-defined functions are copied from the source database to the target database in the transfer operation.
Public property CopyAllUserDefinedTableTypes Gets or sets the Boolean property value that specifies whether all the SQL Server user-defined table types are copied from the source database to the target database in the transfer operation.
Public property CopyAllUserDefinedTypes Gets or sets the Boolean property value that specifies whether all the SQL Server user-defined types are copied from the source database to the target database in the transfer operation.
Public property CopyAllUsers Gets or sets the Boolean property value that specifies whether all the SQL Server database users are copied from the source database to the target database in the transfer operation.
Public property CopyAllViews Gets or sets the Boolean property value that specifies whether all the SQL Server views are copied from the source database to the target database in the transfer operation.
Public property CopyAllXmlSchemaCollections Gets or sets the Boolean property value that specifies whether all the SQL Server XML schema collections are copied from the source database to the target database in the transfer operation.
Public property CopyData Gets or sets the Boolean property value that specifies whether all the data is copied from the source database to the target database in the transfer operation.
Public property CopySchema Gets or sets the Boolean property value that specifies whether the schema is copied from the source database to the target database in the transfer operation.
Public property CreateTargetDatabase Gets or sets the Boolean property value that specifies whether the target database is created in the transfer operation.
Public property Database Gets or sets the database from which schema or data is to be transferred to the target location.
Public property DatabaseFileMappings Gets or sets properties that are associated with flat file destination based on a DatabaseFileMappingsDictionary object.
Public property DestinationDatabase Gets or sets the database that is the destination of the transfer operation.
Public property DestinationLogin Gets or sets the logon for the instance of SQL Server to which the destination database belongs.
Public property DestinationLoginSecure Gets or sets the Boolean property that specifies whether the instance of SQL Server that contains the destination database is enabled for Windows Authentication or not.
Public property DestinationPassword Gets or sets the logon password for the instance of SQL Server to which the destination database belongs.
Public property DestinationServer Gets or sets the instance of SQL Server that owns the database that is the destination of the transfer operation.
Public property DestinationTranslateChar Gets or sets the Boolean property value that specifies whether the transfer operation translates the code page for characters on the destination database.
Public property DropDestinationObjectsFirst Gets or sets the Boolean property value that specifies whether to drop the objects in the destination database before the transfer operation.
Public property ObjectList Gets or sets the objects copied from the source to destination in the transfer operation.
Public property Options Gets or sets the options for the transfer operation.
Public property PrefetchObjects Gets or sets the Boolean property that specifies whether to prefetch the objects before the transfer operation.
Public property PreserveDbo Gets or sets a Boolean value that specifies whether DBO ownerships are retained through the transfer process.
Public property PreserveLogins Gets or sets the Boolean property that specifies whether to preserve logins in the transfer operation.
Public property SourceTranslateChar Gets or sets the Boolean property value that specifies whether the transfer operation translates the code page for characters on the source database.
Public property TargetDatabaseFilePath Gets or sets the path to where the database files will be copied.
Public property TargetLogFilePath Gets or sets the path to where the database files will be copied.
Public property TemporaryPackageDirectory Gets or sets the file location for storage of temporary packages created during the transfer operation.
Public property UseDestinationTransaction Gets or sets the Boolean property value that specifies whether to use the destination transaction.
Top

Community Additions

ADD
Show:
© 2015 Microsoft