Connect to SQL Server

• 1). Click Windows "Start," select "All Programs" and open "Microsoft SQL Server."
  
  
• 2). Select "SQL Server Management Studio." The "SQL Server Connect" window will open.
  
  
• 3). Click "Connect" to connect to the SQL Server engine.
  
  

Create a Publisher Database

• 1). Right-click the "Replication" folder in the "Object Explorer" panel and select "New Publication." The "New Publication Wizard" will open.
  
  
• 2). Click "Next" to open the "Publication Database" window. You can choose the database that sends the data to all its subscribers, along with identifying the data conflicts between the publisher and subscriber database. Select an existing database by highlighting it and click "Next" to open the "Publication Type" window.
  
  
• 3). Select "Merge publication" and click "Next" to open the "Subscriber Types." Select the appropriate option and click "Next." The "Articles" window will open.
  
  
• 4). Select all the objects you want to replicate and click "Next" to open the "Snapshot Agent" window. You can specify the time frame to run the agent. Check the available options.
  
  
• 5). Click the "Change" tab to make modifications to run the snapshot agent schedule. Click "Next" to open the "Snapshot Agent Security."
  
  
• 6). Choose the "Security Settings" tab to configure the Snapshot Agent security. Choose either Windows account or SQL Server Agent service account. Select "Connect to the Publisher" option.
  
  
• 7). Select "By impersonating the process account" and click "OK." The "Complete the Wizard" window will open.
  
  
• 8). Enter a name for the publication and click "Finish" to complete the process.
  
  

Create Subscriber Database

• 1). Right-click the publication for which you want to create subscribers and choose "New Subscription." The "New Subscription Wizard' window will open.
  
  
• 2). Click "Next" to open the "Publication" window. Select the publisher from the drop-down menu and click "Next" to open the "Merge Agent Location" window.
  
  
• 3). Select the option to "Run all agents at the Distributor" and click "Next." The "Subscribers" window will open.
  
  
• 4). Choose the subscribers from the list by clicking the check box and click "Next" to open the "Merge Agent Security" window.
  
  
• 5). Configure the snapshot security settings by clicking "Security Settings."
  
  
• 6). Click "Next" to open the "Synchronization Schedule." You can select "Run Continuously," "Run on demand only" or define your own schedule from the drop-down menu. Click "Finish" to complete the process.