Before you start
This is the first tutorial in a series of three covering the development of a mobile service technician sample application for DB2 Everyplace using Visual Studio .NET 2003 and the .NET framework. The first tutorial introduces developers to the DB2 Everyplace Synchronization client API for .NET to implement the synchronization functionality, which is the foundation of any mobile synchronization solution. The second tutorial will show how to develop for DB2 Everyplace mobile database using DB2 Everyplace .NET Managed Providers for ADO.NET. The third tutorial will show how to develop stored procedures using DB2 tools and the configuration of Sync Server to make the stored procedure available as a remote stored procedure to a mobile application.
Part 1 discusses the following tasks:
- How to implement a synchronization
- How to implement a synchronization progress bar
- How to implement a refresh triggered by the client
- How to implement disabling/enabling subscription sets
- How to implement the cancellation of a sync
- How to use the Sync Client properties
In addition, you will learn about Sync Client properties, including hints for optimizing synchronization time by using them for performance tuning. The final section provides troubleshooting help that you might need during the implementation.
Note: I provide the code of the service technician sample application provided in the C# language.
In order to use this tutorial, you will need a basic understanding of DB2 Everyplace and the mobile device functionalities provided with Visual Studio .NET 2003. If you are familiar with DB2 Everyplace, Visual Studio .NET 2003, and the .NET Framework, skip the Overview and go to the "service technician sample application" section.
Software requirements are (the development and testing was done on configuration):
- Windows XP
- DB2 Everyplace 8.2
- DB2 UDB V8.1 FP5
- Visual Studio .NET 2003
- Service technician sample code from ServTech1CSharp.zip