July 19, 2006 at 7:35 am
I have a Windows 2003 server that runs SQL Server 2000. I also have 2 HP iPAQ pocket pc's. They both have Pocket PC 2003 Prem on them.
What I am trying to do is replicate a database, from the server to the pocket pc's.
Based on my research, I think my server would be the publisher and the distributor. The pocket pc's would be the subscribers. The type of replication I was thinking of using is merge replication.
I also think I need to install SQL Server CE on the pocket pc's. Which version of SQL Server CE would I use with Pocket PC 2003 Prem?
Please let me know if I am on the right track and if I am missing anything.
Thanks for the help.
July 19, 2006 at 1:23 pm
You are on the right track!
Have a look http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/dataset_server_ce.asp
* Noel
July 20, 2006 at 5:42 pm
SQL CE 2.0 would be your most likely candidate.
Talks to SQL Server 2000 via the server side setup of SQL CE 2.0.
Does not require you to apply a different .Net Compact Framework to the device
You could also use SQL Mobile
Talks to SQL Server 2000 via the server side install of SQL Mobile
Does require you to apply a different .Net Compact Framework (2.0) to the device
Your other assumptions fit with what we do here
July 24, 2006 at 7:20 am
Thank you for your help.
Amy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply