This entry was posted on Wednesday, May 25th, 2005 at 1:04 pm and is filed under Uncategorized, Tech data. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.
Merge Replication has four perquisites:
1. You have two servers, with SQL Server and Enterprise Manager installed.
2. On each server you have created the databases that you want to merge.
3. Also the database on the server that will be acting as the Publisher has the complete structure.
4. The service that manages the replication and connects the two SQLservers should manage the SQLSERVERAGENT as well. This account should be the same on both machines and it should have an identical windows authentication and password on both machines.
Data can be added at any time, but the basic structure needs to be in place when the article is established. Changes can be made later so it is not essential to get it absolutely right first time.
Job 1: Configure the main machine as a publisher
The first job is to set up the main machine so that it is configured as a Publisher and Distributor.
Step one: Log on to the main machine and load up Enterprise Manager.
Step two: Right-hand-click on the server symbol for the machine that you’re on. This will bring up a floating menu. Click on the second to last choice ‘Properties’.
Step three: Highlight the Replication tab and click on ‘Configure’
Step four: Continue through the Publishing and Distribution wizard with these settings:
• Click ‘Next’ from the welcome page.
• Go with the default ‘Make XXX it’s own Distributor’ and click ‘Next’
• Make sure the directory name is to your liking and click ‘Next’
• Use the default settings on the ‘Customize the Configuration’ page and click ‘Next’
• Click ‘Finish’ & wait for the system to set up replication.