Microsoft® SQL Server 2012 Unleashed

Creating a Publication

When the distribution database has been created and publishing has been enabled on the server, you can create and configure a publication. In SQL Server Management Studio, you start by locating the Replication node under the publication server from which you want to publish data (the DATAXDESIGN-PC\SQL2012DXD01 named instance in this example). Figure 40.34 shows the program item option when you right-click the Replication node under what will be the publication server. As you can see, there are three options; one to create a new publication, one to create a new Oracle publication, and one to create a new subscription.