How to create publications and define articles (Enterprise Manager)

How to Install SQL Server 2000

How To

How to create publications and define articles (Enterprise Manager)

To create publications

  1. At the Publisher, open SQL Server Enterprise Manager, expand a server group, expand the Replication folder, right-click the Publications folder, and then click New Publication.

  2. On the Welcome to the Create Publication Wizard page, select Show advanced options in this wizard to enable updatable subscriptions or transformable subscriptions (options available with snapshot replication or transactional replication).

  3. The wizard guides you through:
    • Choosing a publication database.

    • Using a publication template.

    • Selecting the type of publication.

    • Selecting updatable subscriptions or transformable subscriptions (snapshot replication or transactional replication).

    • Specifying Subscriber types.

    • Specifying data and database object articles to publish.

    • Selecting a publication name and description. Publication names cannot contain these characters: / \ < >.

    • Customizing the properties of the publication including filtering columns, filtering rows, enabling dynamic filters, validating subscription information, optimizing synchronization, allowing anonymous subscriptions, and setting the snapshot agent schedule.