Fully graphical SQL 2008 database replication

In order to achieve timely data backup, the general use of full backup + differential backup, or plus log backup, this article describes the use of database replication technology to synchronize data:

PS: The main picture of the article, the picture more intuitive to see the operation steps and configuration Method!

1. First create a test database, named Fa_bu, to publish the data, because it is a demo, so there are two fields.

2. Publish the database, here I publish the local FA_BU database.

3. Local subscriptions, where other servers can be selected.

The next step is to select the published server:

The New Database dialog box appears when you choose to create a new database, as follows:

Below you need to set access permissions, click on the Back button to enter the settings interface:

Set schedule below:

4. Now we test, the first query two database data inside, you can find that all is empty.

Now insert a piece of data in the FA_BU database,

Query the data of two databases again, and find that the data has been synchronized, as shown in:

Also hard, please respect the author's labor results, reproduced please specify the original link, thank you!

Fully graphical SQL 2008 database replication