Method of MSSQL database synchronization - Using Enterprise Manager

xiaoxiao2021-03-14  187

First to configure the publishing server

(1) Select the specified [Server] node

(2) Select [Publishing, Subscriber and Distribution] command from the [Copy] submenu of [Tool] drop-down menu

(3) The system pops up a dialog box point [Next] and then look at the prompt that has been operational.

(4) After completing the settings of the publishing server, the system will add a replication monitor to the tree structure of the server. Also generate a distribution database (Distribution)

Second creation publication

(1) Select the specified server

(2) Select [Create and Manage Publish] commands from the [Copy] submenu of the [Tools] menu. At this point, a dialog box will pop up.

(3) Select the database to create a publication, and then click [Create Publish]

(4) Click the [Next] system in the [Create Publish Wizard] to pop up a dialog box. The content on the dialog is three types of replication. We now choose the first one is the default snapshot release (other two can go see help)

(5) Click [Next] System Requirements Specify that you can subscribe to the published database server type, SQL Server allows data replication between different databases such as Oracle or Access. But here we choose the database server running "SQL Server 2000"

(6) Click [Next] The system pops up a dialog box for a definition article is also the table to be published.

(7) Then [Next] until the operation is completed. The database created after the publication is completed, it will become a shared database.

Third design subscription

(1) Select the specified subscription server

(2) Select [Reproduction] submenu from [Tool] drop-down menu [request subscription]

(3) Follow [Next] to operate until the system will prompt the SQL Server Agent Service's running status, the prerequisite for performing replication operations is that the SQL Server Agent service must have started.

(4) Click [Finish]. Complete the subscription operation.

Completing the above steps is actually replication. But how do you know if replication is successful? This can be successfully seen in this way. Expand the copy of the publishing server - Publish content - Right click on the content - Property - Hit - Status The Status is immediately running the agent, then the agent property hits the schedule to set the schedule to every day, every minute It is between 0:00:00 and 23:59:59.

转载请注明原文地址:https://www.9cbs.com/read-129478.html

New Post(0)