Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pokerace
Starting Member
4 Posts |
 Posted - 2008-02-02 : 12:06:00
|
| I would like to create an SQL Server 2005 database that is able to (synchronize or replicate?) information from the main SQL Server database with a version running on windows mobile handheld devices. I will need to elaborate a little bit further to fully explain what I am trying to accomplish. I am building a payroll database using SQL Server 2005. At any given time there might be about 200-300 active people in the database. The supervisors (job coaches) for these employees should be able to enter their daily (hourly) time tracking data. Normally, that would be easy to implement. However, because of the environment and traveling involved, it would be really great if the supervisors could each have their own windows mobile device with a smaller version of the database installed so they can enter data on the fly and then sync it up at the end of each day. They would each only need to enter select data for select employees, and when the data uploads to the main database the data they entered should be automatically deleted from the device.Can I implement such a system using SQL Server and if so, what version(s) would I need to use to make it happen? |
|
|
|
|
|
Using SQL Server for synchronizing with mobile...