TransArticle Constructor ()

 

Creates a new instance of the TransArticle class.

Namespace:   Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

public TransArticle()

The default constructor initializes any fields to their default values.

// 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();
}
Return to top
Show: