TransArticle Costruttori

Definizione

Spazio dei nomi:

Microsoft.SqlServer.Replication

Assembly:

Microsoft.SqlServer.Rmo.dll

Crea una nuova istanza della classe TransArticle.

Overload

TransArticle()	Crea una nuova istanza della classe TransArticle.
TransArticle(String, String, String, ServerConnection)	Crea una nuova istanza della TransArticle classe , con le proprietà necessarie e con la connessione specificata all'istanza di Microsoft SQL Server.

Commenti

Testo aggiornato:17 luglio 2006

Nella tabella seguente vengono illustrati i valori predefiniti delle proprietà per una nuova istanza di TransArticle. Tutte le proprietà non enumerate in modo esplicito in questa tabella vengono inizializzate in un null valore.

Proprietà	Valore predefinito
CachePropertyChanges	false
CommandFormat	Valore di None per CommandOptions
DatatypeMappingOptions	Valore di Default per ArticleDatatypeMappingOptions
DeleteCommand	CALL sp_MSdel_table1
IdentityRangeManagementOption	Valore di Manual per IdentityRangeManagementOption
InsertCommand	CALL sp_MSins_table1
IsExistingObject	false
PreCreationMethod	Valore di Drop per PreCreationOption
SchemaOption	Valore di PrimaryObject per CreationScriptOptions
Type	Valore di LogBased per ArticleOptions
UpdateCommand	SCALL sp_MSupd_table1
VerticalPartition	false

¹ Per altre informazioni, vedere Specificare la modalità di propagazione delle modifiche per gli articoli transazionali e i parametri @del_cmd, @ins_cmd e @upd_cmd di sp_addarticle (Transact-SQL).

TransArticle()

Crea una nuova istanza della classe TransArticle.

public:
 TransArticle();

public TransArticle ();

Public Sub New ()

Esempio

// Define the Publisher, publication, and article names.
string publisherName = publisherInstance;
string publicationName = "AdvWorksProductTran";
string publicationDbName = "AdventureWorks2012";
string articleName = "Product";
string schemaOwner = "Production";

TransArticle article;

// Create a connection to the Publisher.
ServerConnection conn = new ServerConnection(publisherName);

// Create a filtered transactional articles in the following steps:
// 1) Create the  article with a horizontal filter clause.
// 2) Add columns to or remove columns from the article.
try
{
    // Connect to the Publisher.
    conn.Connect();

    // Define a horizontally filtered, log-based table article.
    article = new TransArticle();
    article.ConnectionContext = conn;
    article.Name = articleName;
    article.DatabaseName = publicationDbName;
    article.SourceObjectName = articleName;
    article.SourceObjectOwner = schemaOwner;
    article.PublicationName = publicationName;
    article.Type = ArticleOptions.LogBased;
    article.FilterClause = "DiscontinuedDate IS NULL";

    // Ensure that we create the schema owner at the Subscriber.
    article.SchemaOption |= CreationScriptOptions.Schema;

    if (!article.IsExistingObject)
    {
        // Create the article.
        article.Create();
    }
    else
    {
        throw new ApplicationException(String.Format(
            "The article {0} already exists in publication {1}.",
            articleName, publicationName));
    }

    // Create an array of column names to remove from the article.
    String[] columns = new String[1];
    columns[0] = "DaysToManufacture";

    // Remove the column from the article.
    article.RemoveReplicatedColumns(columns);
}
catch (Exception ex)
{
    // Implement appropriate error handling here.
    throw new ApplicationException("The article could not be created.", ex);
}
finally
{
    conn.Disconnect();
}

' Define the Publisher, publication, and article names.
Dim publisherName As String = publisherInstance
Dim publicationName As String = "AdvWorksProductTran"
Dim publicationDbName As String = "AdventureWorks2012"
Dim articleName As String = "Product"
Dim schemaOwner As String = "Production"

Dim article As TransArticle

' Create a connection to the Publisher.
Dim conn As ServerConnection = New ServerConnection(publisherName)

' Create a filtered transactional articles in the following steps:
' 1) Create the  article with a horizontal filter clause.
' 2) Add columns to or remove columns from the article.
Try
    ' Connect to the Publisher.
    conn.Connect()

    ' Define a horizontally filtered, log-based table article.
    article = New TransArticle()
    article.ConnectionContext = conn
    article.Name = articleName
    article.DatabaseName = publicationDbName
    article.SourceObjectName = articleName
    article.SourceObjectOwner = schemaOwner
    article.PublicationName = publicationName
    article.Type = ArticleOptions.LogBased
    article.FilterClause = "DiscontinuedDate IS NULL"

    ' Ensure that we create the schema owner at the Subscriber.
    article.SchemaOption = article.SchemaOption Or _
    CreationScriptOptions.Schema

    If Not article.IsExistingObject Then
        ' Create the article.
        article.Create()
    Else
        Throw New ApplicationException(String.Format( _
         "The article {0} already exists in publication {1}.", _
         articleName, publicationName))
    End If

    ' Create an array of column names to remove from the article.
    Dim columns() As String = New String(0) {}
    columns(0) = "DaysToManufacture"

    ' Remove the column from the article.
    article.RemoveReplicatedColumns(columns)
Catch ex As Exception
    ' Implement appropriate error handling here.
    Throw New ApplicationException("The article could not be created.", ex)
Finally
    conn.Disconnect()
End Try

Commenti

Il costruttore predefinito inizializza tutti i campi in base ai valori predefiniti.

TransArticle(String, String, String, ServerConnection)

Crea una nuova istanza della TransArticle classe , con le proprietà necessarie e con la connessione specificata all'istanza di Microsoft SQL Server.

public:
 TransArticle(System::String ^ name, System::String ^ publicationName, System::String ^ databaseName, Microsoft::SqlServer::Management::Common::ServerConnection ^ connectionContext);

public TransArticle (string name, string publicationName, string databaseName, Microsoft.SqlServer.Management.Common.ServerConnection connectionContext);

new Microsoft.SqlServer.Replication.TransArticle : string * string * string * Microsoft.SqlServer.Management.Common.ServerConnection -> Microsoft.SqlServer.Replication.TransArticle

Public Sub New (name As String, publicationName As String, databaseName As String, connectionContext As ServerConnection)

Parametri

name

String

Valore String che specifica il nome dell'articolo.

publicationName

String

Valore String che specifica il nome della pubblicazione transazionale o snapshot.

databaseName

String

Valore String che specifica il nome del database di pubblicazione.

connectionContext

ServerConnection

Valore dell'oggetto ServerConnection che specifica la connessione al server di pubblicazione.