all groups > sql server replication > october 2003 >
You're in the

sql server replication

group:

Sync


Sync Kevin
10/30/2003 6:10:07 AM
sql server replication:
I need to man some of my people with laptops in the
field. What is the best way to deploy this kind of system
and sync with the database once they come back to the
office.
Sync Hilary Cotter
10/30/2003 8:10:39 AM
Merge replication was designed for this.
[quoted text, click to view]
Re: Sync Kevin Meadows
10/30/2003 10:32:54 AM
Do I need Developer to deploy?
-Kevin



*** Sent via Developersdex http://www.developersdex.com ***
Re: Sync Hilary Cotter
10/30/2003 7:55:19 PM
No, follow the wizards to do this. In EM go to Tools|Replication|create and
Manage Publications and follow the wizards accepting all defaults.

[quoted text, click to view]

Re: Sync Karthik
11/2/2003 1:43:22 PM
Hi Kevin,

You might need a developer or if you are good at TSQL, you yourself can
handle some areas that might become a problem.

For example, if you have identity fields in your database, how are you going
to handle it? Also, you will have to make sure that all your insert queries
are with column names.... and a few things like these will have to be
ascertained before you actually enable merge replication.

I would advise you to go through BOL before attempting to Synchronize your
database.

Regards,
Karthik.

[quoted text, click to view]

AddThis Social Bookmark Button