Howto setup SQL Replication with a Compact Framework Application .NET2003 and sqlCE
Posted on 2004-03-24
I've been trying for 3 straight days to get replication working, i'm doing something wrong and deciced to ask somebody here at Experts Exchange to provide with some sort of step-by-step tutorial or something like that.
First i would like to say what my goal is for my application.
I have a customer list and i want the customer list in my pocket pc application, there are 200+ customers in my list on my SQL2000 server. it takes 30sec to get the list in my pocket pc application thru a GPRS connection (33k - 56k speed).
I've used RDA pull for this, all works great, but whenever there is a update to the list, i need to drop the local sqlCE table and do a pull again. this again takes 30sec even if there is only 1 record updated. What i want is a system that does a update thus compare tables and only 'pull' the updated record(s).
So after some reading on the internet, i came to the conclusion that I need Replication, and that RDA is not the solution.
perhaps i'm wrong, but i need a way to keep traffic and waiting time for the user at an minimum.
after installing distribution etc.etc. on my SQL2000 server, i can't get it to work. So i decided to take a clean start with help from you.
Any solution is welcome. i'm giving away 500 points for this one, as i need a solid database application. And could really need some good help.
Pocket PC 2003
GPRS T-Mobile NL
Compact framework 1.1 SP1
Sql CE 2.0
SQL Server 2000 Developer Edition
Windows Advanced Server 2000 On a 1Mbit DSL line
Thanks in advance