Sql2008 Replication Publication subscriptions (data synchronization)

Database synchronization Issues

1 A primary database serverAand a different database serverB, the client first accesses the databaseB,whenBThe database server hangs outWhen you visitA,when the databaseBmakeDMLoperation, you alsoAto update, ifAwith theBcommunication failure between,The updated data is stored in a temporary table,When you resume communication,Automatic Updates,and delete the temporary data,also whenBtemporarily exist when the data is not availableAin whichBWhen you resume a connection, AtheBto update,How to achieve?

Database Synchronization Update Step: Mainly uses the MSSQL database replication function (Local publishing and local subscription to complete the primary database server and Database server synchronization)

Condition: 1.Two unitsPCMachine, Environment:Win7Operating System+mssql2008, aPCMaster database Server(Publish), the other onePCdo the database server (subscription). Note:1.ensure that the two unitsPCof theMSSQL2008can access each other's database remotely2.The snapshot file will use theFTPsave it (as described below)

Start: Start the SQL2008 database service on the primary database server as

Connecting to the SQl2008 Server

Create a new database in the SQL2008 database on the primary database server called "Db_test" and a table Msgs, The fields in the Msgs table are as follows

The database and the table are created well.

Create a local publishing step in replication as follows:

To build an ftp Snapshot file, you need to set up an ftp site as follows:

The condition is: to open FTP Port

1. Start Internet Information Services (IIS) Manager

To continue publishing: Go back to the database --- find the Publish "Yangfeizai" action we created

The release is now complete.

Then create the subscription on the database server: steps below

Sql2008 Replication Publication subscriptions (data synchronization)