O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant by William R. Stanek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required