ITransferSqlServerObjectsTask 인터페이스
이 API는 SQL Server 2012 인프라를 지원하기 위한 것으로 코드에서 직접 사용할 수 없습니다.
Represents a Transfer SQL Server Objects task.
네임스페이스: Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask
어셈블리: Microsoft.SqlServer.TransferSqlServerObjectsTask(Microsoft.SqlServer.TransferSqlServerObjectsTask.dll)
구문
‘선언
Public Interface ITransferSqlServerObjectsTask
‘사용 방법
Dim instance As ITransferSqlServerObjectsTask
public interface ITransferSqlServerObjectsTask
public interface class ITransferSqlServerObjectsTask
type ITransferSqlServerObjectsTask = interface end
public interface ITransferSqlServerObjectsTask
ITransferSqlServerObjectsTask 유형에서 다음 멤버를 표시합니다.
속성
| 이름 | 설명 | |
|---|---|---|
.gif "공용 속성") |
CopyAllDefaults | 인프라입니다. Gets or sets a value that indicates whether the transfer includes the SQL Server defaults. |
|
CopyAllLogins | 인프라입니다. Gets or sets a value that indicates whether all the SQL Server logins are copied from the source database to the target database. |
|
CopyAllObjects | 인프라입니다. Gets or sets a value that indicates whether all the SQL database objects of the specified type are transferred from the source to the target database. |
|
CopyAllPartitionFunctions | 인프라입니다. Gets or sets a value that indicates whether all SQL Server partitions are transferred from the source to the target database. |
|
CopyAllPartitionSchemes | 인프라입니다. Gets or sets a value that indicates whether all SQL Server partition schemes are transferred from the source to the target database. |
|
CopyAllRules | 인프라입니다. Gets or sets a value that indicates whether all SQL Server rules are transferred from the source to the target database. |
|
CopyAllSchemas | 인프라입니다. Gets or sets a value that indicates whether all SQL Server schemas are transferred from the source to the target database. |
|
CopyAllSqlAssemblies | 인프라입니다. Gets or sets a value that indicates whether all SQL Server assemblies are transferred from the source to the target database. |
|
CopyAllStoredProcedures | 인프라입니다. Gets or sets a value that indicates whether all SQL Server stored procedures are transferred from the source to the target database. |
|
CopyAllTables | 인프라입니다. Gets or sets a value that indicates whether all SQL Server tables are transferred from the source to the target database. |
|
CopyAllUserDefinedAggregates | 인프라입니다. Gets or sets a value that indicates whether all user-defined aggregates are transferred from the source to the target database. |
|
CopyAllUserDefinedDataTypes | 인프라입니다. Gets or sets a value that indicates whether all user-defined data types are transferred from the source to the target database. |
|
CopyAllUserDefinedFunctions | 인프라입니다. Gets or sets a value that indicates whether all user-defined functions are transferred from the source to the target database. |
|
CopyAllUserDefinedTypes | 인프라입니다. Gets or sets a value that indicates whether all user-defined types are transferred from the source to the target database. |
|
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. |
|
CopyAllViews | 인프라입니다. Gets or sets a value that indicates whether all SQL Server views are transferred from the source to the target database. |
|
CopyAllXmlSchemaCollections | 인프라입니다. Gets or sets a value that indicates whether all XML schema collections are transferred from the source to the target database. |
|
CopyData | 인프라입니다. Gets or sets a value that indicates whether the data is transferred from the SQL Server source to the target database. |
|
CopyDatabaseRoles | 인프라입니다. Gets or sets a value that indicates whether database roles are transferred from the source to the target database. |
|
CopyDatabaseUsers | 인프라입니다. Gets or sets a value that indicates whether database users are transferred from the source to the target database. |
|
CopyForeignKeys | 인프라입니다. Gets or sets a value that indicates whether foreign keys are transferred from the source to the target database. |
|
CopyFullTextIndexes | 인프라입니다. Gets or sets a value that indicates whether full-text properties are transferred from the source to the target database. |
|
CopyIndexes | 인프라입니다. Gets or sets a value that indicates whether indexes are transferred from the source to the target database. |
|
CopyObjectLevelPermissions | 인프라입니다. Gets or sets a value that indicates whether securable objects are included in the transfer from the source to the target database. |
|
CopyPrimaryKeys | 인프라입니다. Gets or sets a value that indicates whether primary keys are transferred from the source to the target database. |
|
CopySchema | 인프라입니다. Gets or sets a value that indicates whether the schema is copied from the source database to the target database. |
|
CopySqlServerLogins | 인프라입니다. Gets or sets a value that indicates whether SQL Server logins are included in the transfer from the source to the target database. |
|
CopyTriggers | 인프라입니다. Gets or sets a value that indicates whether triggers are transferred from the source to the target database. |
|
DefaultsList | 인프라입니다. Gets or sets the default objects to transfer. |
|
DestinationConnection | 인프라입니다. Gets or sets the name of the destination connection. |
|
DestinationDatabase | 인프라입니다. Gets or sets the name of the destination database. |
|
DestinationTranslateChar | 인프라입니다. Gets or sets a value that indicates whether the character data is translated from the destination database. |
|
DropObjectsFirst | 인프라입니다. Gets or sets a value that indicates whether objects at the destination are dropped before copying is started. |
|
ExistingData | 인프라입니다. Gets or sets a value from the ExistingData enumeration to determine whether data should be appended to existing data. |
|
GenerateScriptsInUnicode | 인프라입니다. Gets or sets a value that indicates whether the script generated is in Unicode format. |
|
IncludeDependentObjects | 인프라입니다. Gets or sets a value that indicates whether the dependent objects are included in the transfer. |
|
IncludeExtendedProperties | 인프라입니다. Gets or sets a value that indicates whether extended properties are transferred from the source to the target database. |
|
LoginsList | 인프라입니다. Gets or sets the list of logins to transfer. |
|
PartitionFunctionsList | 인프라입니다. Gets or sets the list of partition functions to transfer. |
|
PartitionSchemesList | 인프라입니다. Gets or sets the list of partition schemes to transfer. |
|
RulesList | 인프라입니다. Gets or sets the list of rules to transfer. |
|
SchemasList | 인프라입니다. Gets or sets the list of schemas to transfer. |
|
SourceConnection | 인프라입니다. Gets or sets the name of the connection manager for the source database. |
|
SourceDatabase | 인프라입니다. Gets or sets the name of the database from which objects will be transferred. |
|
SourceTranslateChar | 인프라입니다. Gets or sets a value that indicates whether the character data is translated from the source database. |
|
SqlAssembliesList | 인프라입니다. Gets or sets the list of SQL Server assemblies to transfer. |
|
StoredProceduresList | 인프라입니다. Gets or sets the list of stored procedures to transfer. |
|
TablesList | 인프라입니다. Gets or sets the list of tables to transfer. |
|
UseCollation | 인프라입니다. Gets or sets a value that indicates whether the transfer should use collations. |
|
UserDefinedAggregatesList | 인프라입니다. Gets or sets a list of user-defined aggregates to transfer. |
|
UserDefinedDataTypesList | 인프라입니다. Gets or sets the list of user-defined data types to transfer. |
|
UserDefinedFunctionsList | 인프라입니다. Gets or sets a list of user-defined functions to transfer. |
|
UserDefinedTypesList | 인프라입니다. Gets or sets a list of user-defined types to transfer. |
|
UsersList | 인프라입니다. Gets or sets a list of users to transfer. |
|
ViewsList | 인프라입니다. Gets or sets a list of views to transfer. |
|
XmlSchemaCollectionsList | 인프라입니다. Gets or sets a list of XML schema collections to transfer. |
맨 위로 이동
참고 항목
참조
Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask 네임스페이스