문서를 영문으로 보려면 영문 확인란을 선택하세요. 마우스 포인터를 텍스트 위로 이동시켜 팝업 창에서 영문 텍스트를 표시할 수도 있습니다.
번역
영문

Transfer 클래스

The Transfer object is a tool object that provides programmatic control over copying of schemas and data to other instances of SQL Server.

네임스페이스:  Microsoft.SqlServer.Management.Smo
어셈블리:  Microsoft.SqlServer.SmoExtended(Microsoft.SqlServer.SmoExtended.dll)

public class Transfer : DataTransferBase, ITransferMetadataProvider

Transfer 유형에서 다음 멤버를 표시합니다.

  이름설명
공용 메서드Transfer()Initializes a new instance of the Transfer class.
공용 메서드Transfer(Database)Initializes a new instance of the Transfer class that uses the specified database as the source of the transfer operation.
맨 위로 이동

  이름설명
공용 속성BatchSizeGets or sets the batch size property.
공용 속성BulkCopyTimeoutGets or sets the operation to complete before it times out.
공용 속성CopyAllDatabaseTriggersGets 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. (TransferBase에서 상속됨)
공용 속성CopyAllDefaultsGets 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. (TransferBase에서 상속됨)
공용 속성CopyAllFullTextCatalogsGets 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. (TransferBase에서 상속됨)
공용 속성CopyAllFullTextStopListsGets 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. (TransferBase에서 상속됨)
공용 속성CopyAllLoginsGets 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. (TransferBase에서 상속됨)
공용 속성CopyAllObjectsGets 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. (TransferBase에서 상속됨)
공용 속성CopyAllPartitionFunctionsGets 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. (TransferBase에서 상속됨)
공용 속성CopyAllPartitionSchemesGets 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. (TransferBase에서 상속됨)
공용 속성CopyAllPlanGuidesGets 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. (TransferBase에서 상속됨)
공용 속성CopyAllRolesGets 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. (TransferBase에서 상속됨)
공용 속성CopyAllRulesGets 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. (TransferBase에서 상속됨)
공용 속성CopyAllSchemasGets 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. (TransferBase에서 상속됨)
공용 속성CopyAllSearchPropertyListsGets 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. (TransferBase에서 상속됨)
공용 속성CopyAllSequencesGets 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. (TransferBase에서 상속됨)
공용 속성CopyAllSqlAssembliesGets 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. (TransferBase에서 상속됨)
공용 속성CopyAllStoredProceduresGets 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. (TransferBase에서 상속됨)
공용 속성CopyAllSynonymsGets 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. (TransferBase에서 상속됨)
공용 속성CopyAllTablesGets 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. (TransferBase에서 상속됨)
공용 속성CopyAllUserDefinedAggregatesGets 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. (TransferBase에서 상속됨)
공용 속성CopyAllUserDefinedDataTypesGets 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. (TransferBase에서 상속됨)
공용 속성CopyAllUserDefinedFunctionsGets 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. (TransferBase에서 상속됨)
공용 속성CopyAllUserDefinedTableTypesGets 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. (TransferBase에서 상속됨)
공용 속성CopyAllUserDefinedTypesGets 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. (TransferBase에서 상속됨)
공용 속성CopyAllUsersGets 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. (TransferBase에서 상속됨)
공용 속성CopyAllViewsGets 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. (TransferBase에서 상속됨)
공용 속성CopyAllXmlSchemaCollectionsGets 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. (TransferBase에서 상속됨)
공용 속성CopyDataGets or sets a value that indicates whether all the data is copied from the source database to the target database in the transfer operation. (TransferBase에서 상속됨)
공용 속성CopySchemaGets or sets a value that indicates whether the schema is copied from the source database to the target database in the transfer operation. (TransferBase에서 상속됨)
공용 속성CreateTargetDatabaseGets or sets a value that indicates whether the target database is created in the transfer operation. (TransferBase에서 상속됨)
공용 속성DatabaseGets or sets the database from which schema or data is to be transferred to the target location. (TransferBase에서 상속됨)
공용 속성DatabaseFileMappingsGets or sets the properties that are associated with flat file destination based on a dictionary. (TransferBase에서 상속됨)
공용 속성DestinationDatabaseGets or sets the database that is the destination of the transfer operation. (TransferBase에서 상속됨)
공용 속성DestinationLoginGets or sets the logon for the instance of SQL Server to which the destination database belongs. (TransferBase에서 상속됨)
공용 속성DestinationLoginSecureGets or sets a value that indicates whether the instance of SQL Server that contains the destination database is enabled for Windows Authentication or not. (TransferBase에서 상속됨)
공용 속성DestinationPasswordGets or sets the logon password for the instance of SQL Server to which the destination database belongs. (TransferBase에서 상속됨)
공용 속성DestinationServerGets or sets the instance of SQL Server that owns the database that is the destination of the transfer operation. (TransferBase에서 상속됨)
공용 속성DestinationTranslateCharGets or sets a value that indicates whether the transfer operation translates the code page for characters on the destination database. (TransferBase에서 상속됨)
공용 속성DropDestinationObjectsFirstGets or sets a value that indicates whether to drop the objects in the destination database before the transfer operation. (TransferBase에서 상속됨)
공용 속성ObjectListGets or sets the objects copied from the source to destination in the transfer operation. (TransferBase에서 상속됨)
공용 속성OptionsGets or sets the options for the transfer operation. (TransferBase에서 상속됨)
공용 속성PrefetchObjectsGets or sets a value that indicates whether to prefetch the objects before the transfer operation. (TransferBase에서 상속됨)
공용 속성PreserveDboGets or sets a value that indicates whether DBO ownerships are retained through the transfer process. (TransferBase에서 상속됨)
공용 속성PreserveLoginsGets or sets a value that indicates whether to preserve logins in the transfer operation. (TransferBase에서 상속됨)
보호된 속성ScripterGets the scripter for the transfer operation. (TransferBase에서 상속됨)
공용 속성SourceTranslateCharGets or sets a value that indicates whether the transfer operation translates the code page for characters on the source database. (TransferBase에서 상속됨)
공용 속성TargetDatabaseFilePathGets or sets the path to where the database files will be copied. (TransferBase에서 상속됨)
공용 속성TargetLogFilePathGets or sets the path to where the log files will be copied. (TransferBase에서 상속됨)
공용 속성TemporaryPackageDirectoryFor internal use only. The value of this property is ignored if set by a caller.
공용 속성UseDestinationTransactionGets or sets a value that indicates whether to use the destination transaction. (TransferBase에서 상속됨)
맨 위로 이동

  이름설명
공용 메서드EnumObjectsReturns an enumerated list of Uniform Resource Name (URN) values that represent the objects included in the transfer operation. (TransferBase에서 상속됨)
공용 메서드EnumScriptTransferCreates a Transact-SQL command batch script used to transfer database objects or database objects and data to another database instance. (TransferBase에서 상속됨)
공용 메서드Equals (Object에서 상속됨)
보호된 메서드Finalize (Object에서 상속됨)
공용 메서드GetHashCode (Object에서 상속됨)
공용 메서드GetTransferProviderFor internal use only. Throws a System.NotSupportedException if invoked by a caller.
공용 메서드GetType (Object에서 상속됨)
보호된 메서드MemberwiseClone (Object에서 상속됨)
보호된 메서드정적 멤버ProcessDependencyChainReturns a URN array with options.
공용 메서드ScriptTransferCreates a Transact-SQL command batch script that creates database objects that are transferred by the transfer operation. (TransferBase에서 상속됨)
보호된 메서드SetTargetServerInfoSets the target server version based on the SQL Server version. (TransferBase에서 상속됨)
공용 메서드ToString (Object에서 상속됨)
공용 메서드TransferDataTransfers data as specified by the Transfer object.
맨 위로 이동

  이름설명
공용 이벤트DataTransferEventReports that data has been transferred.
공용 이벤트DiscoveryProgressMarks the progress of the discovery process. (TransferBase에서 상속됨)
공용 이벤트ScriptingErrorReports that an error occurred during the scripting process. (TransferBase에서 상속됨)
공용 이벤트ScriptingProgressMarks the progress of the scripting process. (TransferBase에서 상속됨)
맨 위로 이동

  이름설명
명시적 인터페이스 구현전용 메서드ITransferMetadataProvider.GetOptionsThe ITransferMetadataProvider class represents an interface that implements the transfer metadata process on the referenced connection.
명시적 인터페이스 구현전용 메서드ITransferMetadataProvider.SaveMetadataSaves metadata when transferring databases across instances.
맨 위로 이동

The following object types cannot be transferred:

  • All broker objects

  • All mail objects

  • Endpoint

  • ServerDdlTrigger

  • ExtendedStoredProcedure

  • FullTextCatalog

  • UserDefinedMessage

  • ApplicationRole

To get and set Transfer object properties, users can be a member of the public fixed server role.

To transfer data, users can be a member of the public fixed server role.

Thread Safety

이 유형의 모든 public static(Microsoft Visual Basic의 경우 공유) 멤버는 다중 스레드 작업을 수행하기에 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.  

이 유형의 모든 공용 static(Visual Basic에서는 Shared) 멤버는 스레드로부터 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.

커뮤니티 추가 항목

추가
표시: