Transfer Properties

  Name Description
ms220460.pubproperty(en-US,SQL.90).gif CopyAllDatabaseTriggers
Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server database triggers are copied from the source database to the target database in the transfer operation.
ms220460.pubproperty(en-US,SQL.90).gif CopyAllDefaults
Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server defaults are copied from the source database to the target database in the transfer operation.
ms220460.pubproperty(en-US,SQL.90).gif CopyAllLogins
Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server logins are copied from the source database to the target database in the transfer operation.
ms220460.pubproperty(en-US,SQL.90).gif CopyAllObjects
Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server objects are copied from the source database to the target database in the transfer operation.
ms220460.pubproperty(en-US,SQL.90).gif CopyAllPartitionFunctions
Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server partition functions are copied from the source database to the target database in the transfer operation.
ms220460.pubproperty(en-US,SQL.90).gif CopyAllPartitionSchemes
Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server partition schemes are copied from the source database to the target database in the transfer operation.
ms220460.pubproperty(en-US,SQL.90).gif CopyAllRoles
Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server roles are copied from the source database to the target database in the transfer operation.
ms220460.pubproperty(en-US,SQL.90).gif CopyAllRules
Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server rules are copied from the source database to the target database in the transfer operation.
ms220460.pubproperty(en-US,SQL.90).gif CopyAllSchemas
Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server schemas are copied from the source database to the target database in the transfer operation.
ms220460.pubproperty(en-US,SQL.90).gif CopyAllSqlAssemblies
Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server assemblies are copied from the source database to the target database in the transfer operation.
ms220460.pubproperty(en-US,SQL.90).gif CopyAllStoredProcedures
Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server stored procedures are copied from the source database to the target database in the transfer operation.
ms220460.pubproperty(en-US,SQL.90).gif CopyAllSynonyms
Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server synonyms are copied from the source database to the target database in the transfer operation.
ms220460.pubproperty(en-US,SQL.90).gif CopyAllTables
Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server tables are copied from the source database to the target database in the transfer operation.
ms220460.pubproperty(en-US,SQL.90).gif CopyAllUserDefinedAggregates
Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server user-defined aggregates are copied from the source database to the target database in the transfer operation.
ms220460.pubproperty(en-US,SQL.90).gif CopyAllUserDefinedDataTypes
Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server user-defined data types are copied from the source database to the target database in the transfer operation.
ms220460.pubproperty(en-US,SQL.90).gif CopyAllUserDefinedFunctions
Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server user-defined functions are copied from the source database to the target database in the transfer operation.
ms220460.pubproperty(en-US,SQL.90).gif CopyAllUserDefinedTypes
Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server user-defined types are copied from the source database to the target database in the transfer operation.
ms220460.pubproperty(en-US,SQL.90).gif CopyAllUsers
Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server database users are copied from the source database to the target database in the transfer operation.
ms220460.pubproperty(en-US,SQL.90).gif CopyAllViews
Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server views are copied from the source database to the target database in the transfer operation.
ms220460.pubproperty(en-US,SQL.90).gif CopyAllXmlSchemaCollections
Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server XML schema collections are copied from the source database to the target database in the transfer operation.
ms220460.pubproperty(en-US,SQL.90).gif 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.
ms220460.pubproperty(en-US,SQL.90).gif 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.
ms220460.pubproperty(en-US,SQL.90).gif CreateTargetDatabase
Gets or sets the Boolean property value that specifies whether the target database is created in the transfer operation.
ms220460.pubproperty(en-US,SQL.90).gif Database
Gets or sets the database from which schema or data is to be transferred to the target location.
ms220460.pubproperty(en-US,SQL.90).gif DestinationDatabase
Gets or sets the database that is the destination of the transfer operation.
ms220460.pubproperty(en-US,SQL.90).gif DestinationLogin
Gets or sets the logon for the instance of Microsoft SQL Server to which the destination database belongs.
ms220460.pubproperty(en-US,SQL.90).gif DestinationLoginSecure
Gets or sets the Boolean property that specifies whether the instance of Microsoft SQL Server that contains the destination database is enabled for Microsoft Windows Authentication or not.
ms220460.pubproperty(en-US,SQL.90).gif DestinationPassword
Gets or sets the logon password for the instance of Microsoft SQL Server to which the destination database belongs.
ms220460.pubproperty(en-US,SQL.90).gif DestinationServer
Gets or sets the instance of Microsoft SQL Server that owns the database that is the destination of the transfer operation.
ms220460.pubproperty(en-US,SQL.90).gif DestinationTranslateChar
Gets or sets the Boolean property value that specifies whether the transfer operation translates the code page for characters on the destination database.
ms220460.pubproperty(en-US,SQL.90).gif DropDestinationObjectsFirst
Gets or sets the Boolean property value that specifies whether to drop the objects in the destination database before the transfer operation.
ms220460.pubproperty(en-US,SQL.90).gif ObjectList
Gets or sets the objects copied from the source to destination in the transfer operation.
ms220460.pubproperty(en-US,SQL.90).gif Options
Gets or sets the options for the transfer operation.
ms220460.pubproperty(en-US,SQL.90).gif PrefetchObjects
Gets or sets the Boolean property that specifies whether to prefetch the objects before the transfer operation.
ms220460.pubproperty(en-US,SQL.90).gif SourceTranslateChar
Gets or sets the Boolean property value that specifies whether the transfer operation translates the code page for characters on the source database.
ms220460.pubproperty(en-US,SQL.90).gif TargetDatabaseFilePath  
ms220460.pubproperty(en-US,SQL.90).gif TargetLogFilePath  
ms220460.pubproperty(en-US,SQL.90).gif TemporaryPackageDirectory
Gets or sets the file location for storage of temporary packages created during the transfer operation.
ms220460.pubproperty(en-US,SQL.90).gif UseDestinationTransaction
Gets or sets the Boolean property value that specifies whether to use the destination transaction.

Community Additions

ADD
Show: