Compartir a través de


Clase TransferBase

Represents the base class for transfer.

Jerarquía de herencia

System.Object
  Microsoft.SqlServer.Management.Smo.TransferBase
    Microsoft.SqlServer.Management.Smo.DataTransferBase

Espacio de nombres:  Microsoft.SqlServer.Management.Smo
Ensamblado:  Microsoft.SqlServer.SmoExtended (en Microsoft.SqlServer.SmoExtended.dll)

Sintaxis

'Declaración
Public MustInherit Class TransferBase
'Uso
Dim instance As TransferBase
public abstract class TransferBase
public ref class TransferBase abstract
[<AbstractClassAttribute>]
type TransferBase =  class end
public abstract class TransferBase

El tipo TransferBase expone los siguientes miembros.

Constructores

  Nombre Descripción
Método público TransferBase() Initializes a new instance of the TransferBase class.
Método público TransferBase(Database) Initializes a new instance of the TransferBase class that uses the specified database as the source of the transfer operation.

Arriba

Propiedades

  Nombre Descripción
Propiedad pública 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.
Propiedad pública 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.
Propiedad pública 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.
Propiedad pública 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.
Propiedad pública 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.
Propiedad pública 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.
Propiedad pública 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.
Propiedad pública 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.
Propiedad pública 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.
Propiedad pública 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.
Propiedad pública 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.
Propiedad pública 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.
Propiedad pública 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.
Propiedad pública 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.
Propiedad pública 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.
Propiedad pública 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.
Propiedad pública 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.
Propiedad pública 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.
Propiedad pública 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.
Propiedad pública 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.
Propiedad pública 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.
Propiedad pública 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.
Propiedad pública 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.
Propiedad pública 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.
Propiedad pública 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.
Propiedad pública 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.
Propiedad pública 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.
Propiedad pública 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.
Propiedad pública CreateTargetDatabase Gets or sets a value that indicates whether the target database is created in the transfer operation.
Propiedad pública Database Gets or sets the database from which schema or data is to be transferred to the target location.
Propiedad pública DatabaseFileMappings Gets or sets the properties that are associated with flat file destination based on a dictionary.
Propiedad pública DestinationDatabase Gets or sets the database that is the destination of the transfer operation.
Propiedad pública DestinationLogin Gets or sets the logon for the instance of SQL Server to which the destination database belongs.
Propiedad pública 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.
Propiedad pública DestinationPassword Gets or sets the logon password for the instance of SQL Server to which the destination database belongs.
Propiedad pública DestinationServer Gets or sets the instance of SQL Server that owns the database that is the destination of the transfer operation.
Propiedad pública DestinationTranslateChar Gets or sets a value that indicates whether the transfer operation translates the code page for characters on the destination database.
Propiedad pública DropDestinationObjectsFirst Gets or sets a value that indicates whether to drop the objects in the destination database before the transfer operation.
Propiedad pública ObjectList Gets or sets the objects copied from the source to destination in the transfer operation.
Propiedad pública Options Gets or sets the options for the transfer operation.
Propiedad pública PrefetchObjects Gets or sets a value that indicates whether to prefetch the objects before the transfer operation.
Propiedad pública PreserveDbo Gets or sets a value that indicates whether DBO ownerships are retained through the transfer process.
Propiedad pública PreserveLogins Gets or sets a value that indicates whether to preserve logins in the transfer operation.
Propiedad protegida Scripter Gets the scripter for the transfer operation.
Propiedad pública SourceTranslateChar Gets or sets a value that indicates whether the transfer operation translates the code page for characters on the source database.
Propiedad pública TargetDatabaseFilePath Gets or sets the path to where the database files will be copied.
Propiedad pública TargetLogFilePath Gets or sets the path to where the log files will be copied.
Propiedad pública UseDestinationTransaction Gets or sets a value that indicates whether to use the destination transaction.

Arriba

Métodos

  Nombre Descripción
Método público EnumObjects Returns an enumerated list of Uniform Resource Name (URN) values that represent the objects included in the transfer operation.
Método público EnumScriptTransfer Creates a Transact-SQL command batch script used to transfer database objects or database objects and data to another database instance.
Método público Equals (Se hereda de Object.)
Método protegido Finalize (Se hereda de Object.)
Método público GetHashCode (Se hereda de Object.)
Método público GetType (Se hereda de Object.)
Método protegido MemberwiseClone (Se hereda de Object.)
Método público ScriptTransfer Creates a Transact-SQL command batch script that creates database objects that are transferred by the transfer operation.
Método protegido SetTargetServerInfo Sets the target server version based on the SQL Server version.
Método público ToString (Se hereda de Object.)

Arriba

Eventos

  Nombre Descripción
Evento público DiscoveryProgress Marks the progress of the discovery process.
Evento público ScriptingError Reports that an error occurred during the scripting process.
Evento público ScriptingProgress Marks the progress of the scripting process.

Arriba

Seguridad para subprocesos

Cualquier miembro público static (Shared en Visual Basic) de este tipo es seguro para subprocesos. No se garantiza que los miembros de instancia sean seguros para subprocesos.

Vea también

Referencia

Espacio de nombres Microsoft.SqlServer.Management.Smo