The article refers to the hundred spent articles, because the version of the different, the operation also encountered a lot of problems, now tidy up, I hope to help you friends. Publish a subscription for two steps: 1, release. 2 subscriptions. You first publish the data that needs to be synchronized on the data source database server, and then subscribe to the above publication on the target database server.
The publication requires an actual server name and cannot be performed using the server's IP address. The information that can be published includes "table", "Stored procedure", "User Function", Release 1, locate "copy" under the database server--"Local publishing", select "New publication". For example: 2, select "Next" (e.g.) 3, select "Next" 4, select "Auto Start" by default, then select "Next" 5, "default path" C:\Program Files\Microsoft SQL Server\mssql11. Mssqlserver\mssql\repldata "and then select" Next "if it is not backed up to local, the path (local shared directory-need to set permissions for this folder) needs to be filled in as: \\192.168.2.202\ shared directory \99. Other \test 6, select the database to be published (for example), select the database and then click "Next" 7, select the publication type. The default type of "Snapshot publication" is selected here. Several types of publishing differ, and SQL Server gives instructions (such as) below. Then select "Next" 8, select the class capacity to be published (among the optional types include: table, stored procedure, user-defined function), this demo of the database is only the table, here all selected (such as). Then select Next 9, where you can add criteria for filtering the table, and click Add to filter the criteria. 10, add filter conditions, such as the demonstration here does not need to add, so click "Cancel" and then select "Next" in the right is filtered SQL statement. 11. Set up the Snapshot Agent. such as: 12, change the synchronization frequency, such as, the default settings, the direct "OK" can 13, set the agent security (such as), click on "Security Settings" 14, "OK" after the setting is completed 15, after the security settings, and then click "Next"
16, fill out the release name 17, complete the release. such as: 18, after the successful release of "Copy" will change, such as Second, subscribing to a subscription is a snapshot of a database publication that synchronizes the published data source data to the target database. The specific subscription process is as follows; 1. Locate replication under the database server-local subscription, and select New subscription. such as: 2, default Select Next 3, select the publication of the subscription (for example), select "Find SQL Server Publisher ..." 4, fill out the publisher name, and then "connect"  5, select the database EP-2 (such as) to synchronize, and then select "Next" 6, select the location of the Distribution Agent (such as), depending on the specific business specific analysis of how to choose, here choose to manage the subscription by the Distributor, click "Next" to select the push subscription mode, The request subscription also has a problem, in the change. 7, select one or more target databases on the subscriber that hold the synchronized data, and select ES-2 here. such as: 8, you can also select "New database" (such as), enter the database name, and then "OK" 9, to add multiple subscription databases, click "Add Subscriber" (such as), and then connect to other Subscribers, and select or create a database.   10, after the subscriber determines, select Next (for example) 11, set the Distribution Agent's security (for example), and then click the "... "Set security options," OK "select" Next " 12, set up a synchronous agent plan, here by default (e.g.), then" Next " 13, initialize the subscription (e.g.), default selection, and then" next "  14, default selection, then "Next" 15, click "Finish", complete the subscription (such as) completed the entire process of publishing and subscribing. 16, go back to Publisher replication-Local publishing-EP-2, you can see the associated subscription 17, right-click Start Replication Monitor (M) If you cannot connect to the database during the initialization of the subscription , it is likely that the "1433" port is not added to the firewall's inbound rules because SQL SERVER2012 is enabled by default to allow remote connections. In addition, some of the SQL Server services are not turned on, please go to the configuration file to open. 2015.10.28 9:40 Willem Database synchronization operation steps to organize records 2016.4.14 17:21 Willem Notes update
SQLSERVER2012 Database synchronization publication + subscription
