MS SQL DB availability to offline users ? Is it possible

[MLamanna]

I wanted to know if there is an existing solution where I can provide mobile users with a replica/copy of the Database, allow them to work offline, then merge/copy any changes into the production database, while maintaining some data integrity between the multiple copies that will exist between the mobile users ?
I wonder if providing them a copy of the DB on their laptop running Microsoft SQL personal edition, if they would be able to "work offline" then import any changes?
Remote connectivity is not an option..
Thanks in Advance,

 

[foxdev]

Sure - use Merge Replication. --------------
Low Cost Prints:

http://www.lowcostprints.com