Tuesday, March 27, 2012

Does SQL replication

Hi all,
I am looking to develop a handheld device that requires online and offline
data synchronisation with a central SQL server 2000. I have been reading up
on SQL merge replication to implement this functionality. Has anybody
implemented this type of functionality before and if so how did the merge
replication work for you and how did you find it. I have heard reports the
SQL replication does not work efficiently, so before i implement replication
i would like to get some feedback from people who may have used merge
replication before. Any help would be great.
one of the more large implementations of SQL Ce and merge replication has
1500 clients IIRC, and it works extremely reliably. This is on SQL CE and
SQL 2000. The company is Nabisco and nestle IIRC, there are case studies on
Microsoft's web site about this.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sanjo" <sanjo@.discussions.microsoft.com> wrote in message
news:4FE5598C-FDC1-42ED-BEF7-77E664B7398A@.microsoft.com...
> Hi all,
> I am looking to develop a handheld device that requires online and offline
> data synchronisation with a central SQL server 2000. I have been reading
> up
> on SQL merge replication to implement this functionality. Has anybody
> implemented this type of functionality before and if so how did the merge
> replication work for you and how did you find it. I have heard reports the
> SQL replication does not work efficiently, so before i implement
> replication
> i would like to get some feedback from people who may have used merge
> replication before. Any help would be great.
>

No comments:

Post a Comment