Using the Create Publication Wizard

If you are a member of the sysadmin fixed server role, you can use the Create Publication Wizard to enable a database for publication and select tables or stored procedures (except in merge publications) as articles to be published.

If you are not a member of the sysadmin role, but are a member of the db_owner fixed database role, then you must have a member of the sysadmin role enable the database for you.

After the database has been enabled, you can also use the Create Publication Wizard to specify what types of subscriptions are allowed, how the subscriptions are synchronized initially, and the format in which the data will be published to the Subscribers.

When you create a snapshot or transactional publication, you can:

• Specify that the publication is a transactional publication.
• Select the tables to publish as articles.

  When you select a table as an article, you can filter the data in the article.

• Select stored procedures to publish as articles for transactional publications.

  When you select a stored procedure as an article, you can modify the article properties.

• Allow synchronous update subscriptions.
• Allow anonymous subscriptions.
• Specify whether to maintain a snapshot of the publication at the Distributor.
• Specify the types of Subscribers that will be allowed to subscribe to the publication.

  If all Subscribers will be servers running Microsoft® SQL Server™, the data is published in native format. If one or more Subscribers will be heterogeneous data sources, the data is published in character-mode format.

• Specify a name and a description for the publication.

When you create a merge publication, you can:

• Specify that the publication is a merge publication.
• Select the tables to publish as articles.

  When you select a table as an article, you can filter the data in the article.

• Allow anonymous subscriptions.
• Specify the types of Subscribers that will be allowed to subscribe to the publication.

  If all Subscribers will be servers running SQL Server, the data is published in native format. If one or more Subscribers will be heterogeneous data sources, the data is published in character-mode format.

• Specify a name and a description for the publication.

To start the Create Publication Wizard