Creating and Managing Publications

After you have configured a distributor and enabled publishers, publication databases, and subscribers, you can create publications. You will manage the publications you create as you would any other SQL Server resource.

Creating Publications

The easiest way to create publications is by using SQL Server Management Studio. To do this, complete the following steps:

  1. Start SQL Server Management Studio. In the Object Explorer view, connect to the server you want to use, and then work your way down to the Replication folder.

  2. Right-click the Local Publications folder, and then select New Publication. This starts the New Publication Wizard. Click Next to skip the Welcome screen.

    Note

    If you want to create an Oracle publication, ...

Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial