you can then use SQL Server Management Studio
to create publications that subscribing servers may receive. Each publication
contains a collection of database objects that will be replicated to all subscriber
servers.
With SSMS open, expand the Replication folder of the publisher and right-click on Local Publications. Then select New Publication from the pop-up menu.
With SSMS open, expand the Replication folder of the publisher and right-click on Local Publications. Then select New Publication from the pop-up menu.
Choose the Publication Database
Choose Publication Type
As shown in the figure above, select the publication
type you wish to use:
- Snapshot publication
- Transactional publciation
- Transactional publication with updatable subscriptions
- Merge publication
Press the Next button to continue.
Choose Article to Publish
Next, you must select the specific articles (objects)
within the database that you wish to include in the publication. These are the
objects that will be replicated across all subscribers. You may select any
tables, user-defined functions or stored procedures. Once you've selected
the items you wish to publish, click the Next button to continue
Configuring the Snapshot Agent
You'll want to advance past the Filter Table Rows screen,
unless you wish to limit the data included in the publication. On the next
screen, you'll have the option to create a snapshot immediately and/or create a
schedule for future snapshots using the Snapshot Agent.
Click on the Security
Settings button to provide the account and connection details for the
Snapshot Agent, as shown above. Once you've provided the details, click OK to
close the Snapshot Agent Security screen and click the Next button to continue.
Finishing Up
Click through to the final screen of the wizard, which
allows you to set the publication name. Once you've provided a descriptive
name, click the Finish button to create the publication. You'll see the status
window shown above while SQL Server creates your new publication.
No comments:
Post a Comment