Abstract
Data Management in mobile computing poses great challenges to the database researchers. One of the important challenges is to provide a data replication solution, suitable for various applications in the mobile environment. Because of this difficulty, this paper interested to address a solution customized to one of most important areas in our live that is traffic control area, because this area strongly demand solutions for managing and maintaining data distributed between multiple sites. Our solution is based on the use of optimistic replication, which is the best technique for sharing data efficiently in mobile environment. The solution is applied by using Microsoft SQLSERVER replication types: Snapshot replication, Merge replication, and Transactional replication, and adaptation of some activities of these techniques to ensure availability and consistency of data.