building a ppc application

[Guest]

Hi All,

I am newbie to Pocket PC development; I have decent experience in .Net
Windows and Web. I am writing this not to ask any technical question but to
get an idea for developing an application. My employer asked me build a
Stocktaking application in PPC. The database has around 30,000 items and they
want the ability to do off-line and on-line stocktaking. The Item table has
around 25 columns, but for off-line basically I download 5 columns ( code
nvarchar(25), description nvarchar(30), quantity float , price money ,
location nvarchar(25) ). Now my question is when I download 30,000 items
into PPC; what sort of approach I should take into consideration because I
built small apps in PPC and that apps connected to SQL Server 2000 and
downloads the items into the local SQL Server CE 2.0 database. It takes hell
lot of time to download these items. What will I do in this scenario? What is
best way of building these sort of application. What is the best way to
approach this issue? Please guys help me in this issue and share your ideas.

Thanks
Tom

 

[Guest]

I assume the 30k items doesn't change that often? Replication is the
typical way to handle this.

-Chris

 

[Guest]

Guys...pls put some feedback. i expected more.. MPV's give me a solution?

 

[Felix Joachim]

Hi,

are you using the replication features of SQL Server 2000?

felix

 

[Arun]

Hi Thomas,

Check this synchronization options in this link,
http://groups-beta.google.com/group...amework.compactframework/msg/93dd78af5ab58ecc

But the information that you have provided, we are not in possition to
understand whether you are using Replication or RDA or Web Services or
directly querying SQL Server for your synchronization. First clear that
aspect.
Every approach has pros and cons.
Try with Merge Replication, I feel it best suits you, as the first
synchronization will take time and the subsequent synchronizations will
be faster.

Hope this helps,
Cheers,
Arun.
www.innasite.com