Merge Replication Steps for synchronization between PDA and Sql Server2005

Posted Date: 17 Jul 2008	Resource Type: Tips	Category: General
Author: lavanya devineni	Member Level: Silver
Rating:	Points: 3

First you need to create Snapshot folder in any of directories.
after that share that folder by typing command
"NET SHARE sharename=D:\FolderName"
in Commandpromt.

Merge replication steps
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
1. Expand a replication in the database server

2. Right click the Local Publication and select the New Publication...
a. In New Publication Wizard steps...
-- Publication Database:Select a exact data base that we are going to replicate.
-- Publication Type: Select a Merge Replication
-- Subscriber Types: Check the SQL Server 2005 Mobile Edition
-- Articles: Check the tables that are going to publish the data to subscriber...
-- Snapshot Agent: Check the "Create a snapshot immediately" only.
-- Agent Security: Click the "Security Settings" and get the new window as called a
"Snapshot Agent Security", In this....
Select this option "Run under the SQL Server Agent service account"
In "Connect to the Publisher"
Select this option "Using the following SQL Server login"
and set it up the Publisher Login and password stuffs....
-- Wizard Actions: Check the 2 check boxes in the that page.
Give the file path for "Script File Properties" in the File name: entry box.
-- Complete the Wizard: Finally give the publication name in the entry box and finish it off the process for
"New Publication..." wizard.

b. Right click the publication and select the properties.
-- General: In "Subscription expiration" select the second one "Subscriptions never expire".
-- Snapshot: In "Location of snapshot files"
check the "Put files in the following folder:" and specify the Snapshot share path.
ex:- "\\machinename\sharename" in from "NET SHARE sharename = folder path".

C. Right click the publication and select the "View Snapshot Agent Status" and click the "Start" button.
See the last status meesage as like a "[100%]A snapshot of x article[s] was generated.

3. Configure Web Syncronization wizard....
-- Subscriber Type: Select a "SQL Server Mobile Edition".
-- Web Server: Select a "Create a new virtual directory" and select the "Default Web Site".

-- Virtual directory information: Give a "Alias:" name in the entry box.
-- Client Authentication: Select a option "Clients will connect anonymously...."
-- Snapshot Share Access: Give a Snapshot share name like...\\machinename\Sharename....

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Merge Replication in Sql Server 2005 . Merge Replication .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: My Interview Quesions
	Previous Resource: Microsoft SQL server VS MySQL
	Return to Discussion Resource Index
	Post New Resource
	Category: General

Post resources and earn money!

More Resources