Steps for Configuring Publications

To configure each publication, start in Enterprise Manager on the Publisher server (SQLServer1 in this case) and complete the following steps:

  1. Select Replication, Publications. Right-click, then choose New Publication.
  2. The Create Publication wizard appears. Click Next.
  3. On the Choose Publication Database screen, select the database (ClientDB in this case), then click Next.
  4. If the Use Publication Template screen appears, select No, I will define the articles and properties, then click Next. On the Select Publication Type screen, choose Merge publication, then click Next.
  5. On the Specify Subscriber Types screen, select only Servers running SQL Server 2000, then click Next.
  6. On the Specify Articles screen, in the Show column in the left panel, make sure that only Tables is selected and verify that Show unpublished objects is selected.
  7. In the right panel select the tables that you want to replicate.
  8. If the table has an IDENTITY column, as Figure A shows, click the elipses (...) button next to the article and click the Identity Range tab. Then select Automatically assign and maintain a unique identity range for each subscription.
  9. Enter sufficiently large values in the Range Size at Publisher and Range Size at Subscriber text boxes. (For example, based on the projected growth for the table that has about 1,500,000 million rows, I entered 10,000,000 here.)
  10. In the Assign a new range when the percentage of values is used text box, type 99, then click OK.
  11. After you've selected all articles and modified their properties, click Next.
  12. If the Article Issues screen appears, make sure that only one issue, uniqueidentifier columns will be added to tables, exists. If there is an issue related to IDENTITY columns of one or more tables, return to the previous screen and edit the article properties as I described. If there is only one issue in the list, review the description in the Article Issues screen, then click Next.
  13. On the Select Publication Name and Description screen, type the publication name. Note that you can't later change the assigned publication name. Enter a meaningful publication description, then click Next.
  14. On the Customize the Properties of the Publication screen, choose Yes, I will define data filters, then click Next.
  15. On the Filter Data screen (without any selections), click Next. (You can enter criteria for filtering rows here.)
  16. On the Allow Anonymous Subscriptions screen, select No, allow only named subscriptions, then click Next.
  17. On the Set Snapshot Agent Schedule screen, accept the default options. Ensure that Create the first snapshot immediately is selected, then click Next. (Or you can schedule to run Snapshot Agent later, at a more convenient time.)
  18. On the Completing the Create Publication screen, click Finish, and close any messages that appear.
  19. In the right panel of Enterprise Manager, watch the Replication Monitor, Agents, and Snapshot Agents progress as the snapshot is generated.
  20. Repeat steps 1–20 for all publications.
Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.