Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Howto setup SQL Replication with a Compact Framework Application .NET2003 and sqlCE

Avatar of donkie9999
donkie9999 asked on
Microsoft SQL Server
25 Comments1 Solution1296 ViewsLast Modified:
Hello all,

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.

Some specs:
Pocket PC 2003
GPRS T-Mobile NL
.NET 2003
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
Avatar of danblake

Our community of experts have been thoroughly vetted for their expertise and industry experience.

This problem has been solved!
Unlock 1 Answer and 25 Comments.
See Answers