SQL Server database synchronization problem sharing (2)

SQL Server database synchronization question sharing [unfinished, To be continued] (1) SQL Server database synchronization question sharing (2) --- operation step [unfinished, To be continued] SQL Server database synchronization question sharing (3) --- create the subscription settings above. If some table fields are not specified for publishing in the database table, it is not allowed during filtering.

SQL Server database synchronization problem sharing [not complete, to be continued] (1) SQL Server database synchronization problem sharing (2) --- operation steps [not complete, to be continued] SQL Server database synchronization problem sharing (3) --- create the subscription settings above. If some table fields are not specified for publishing in the database table, it is not allowed during filtering.

SQL Server database synchronization question sharing [unfinished, To be continued] (1)

SQL Server database synchronization problem sharing (2) --- operation steps [unfinished, To be continued]

SQL Server database synchronization problem sharing (3) --- create a subscription

If some table fields are not specified for publishing, the Publishing Database machine cannot be used as the distribution server during filtering, in general, we also do this. Of course we can also use other machines as the distribution server. here we need to configure the distribution server by ourselves. Here we have configured the machine name ing. For details, refer

(1) Start the SQL Server service

Use Database Synchronization to start at least two services

As shown in, you need to start the database instance server and proxy service. Pay attention to the logon authentication method here.

(2) SQL Agent logon Mode

The SQL Agent uses the Local Account Logon mode. if the service is in the non-local account logon mode, you need to modify the configuration.

Here we use the machine administrator to log on. It is best to set a machine logon password. Note that this is not an SQL Logon account but an account for machine logon. Then reference and restart the service

(3) SQL Publishing Server alias Configuration

Here, configure the alias of the Publishing Server. Note that the port number entered here is port 1433 by default.

After this configuration, you can use an alias to log on to the remote machine, instead of an IP address. The ip address cannot be used to create a release.

Of course, we can also use the Hosts file for ing. For details, refer to the following section.

(4) modify the IP address mapped to the Hosts file

Find the hosts file on drive C, which is under the C: \ Windows \ System32 \ drivers \ etc \ directory
Open this file in notepad and modify the following content:

The machine name ing is configured here. For more information, see

(5) Create and release

(6) Specify the Publishing Server

You can use the database publishing machine as the distribution server. We usually do the same. Of course, we can also use other machines as the distribution server. here we need to configure the distribution server by ourselves.

(7) Specify the snapshot storage location

(8) Database for publishing and Replication

(9) specifying the release type

Transaction publishing is used as a case. The features of transaction publishing have been introduced.

(10) Select the database table to be synchronized

(11) Release of database tables without primary keys

Transactions cannot be published without a primary key. As mentioned above

(12) filtering and synchronizing data

If some table fields in the database table are not specified for publishing, it is not allowed during filtering.

(13) proxy running timing settings

The above settings are as follows:

(14) Proxy Security Settings

(15) Release name

Space issue, to be continued, complete document download