June 22, 2009 at 5:12 am
We're making a SFA ( Sales Foce Automation ) Running in a HTC Touch 3G ( SmartPhone ) device.
I have to create a communication layer for Synchronization bettwen my devices and the server. Any Idea? For Example. I send the invoice header and after that the invoice itens. How to be sure that all itens have been Synchronized? How to get only the updates ( A new client has been assigned to a Sales Man )? For license reasons we can't make a direct connections between sqlce and sql server. Thanks in Advance.
July 28, 2009 at 6:40 am
Please visit us at http://www.euremis.com
July 28, 2009 at 7:09 am
Sorry. I don't want to buy a SFA Software, I want to discuss about DataBase Strategies for sync on remote Smart Devices DataBase ( SQLCE 3.5 ) with no direct sync on my Sql Sever 2008.
July 28, 2009 at 7:28 am
use the merge replication and add additional filtres ... look at the MSDN :Whistling:
July 28, 2009 at 8:27 am
This solution requires more SQL Server Lincenses. I can't do that . I also use smartkeys on my Serve database so I need temp keys on my remote databases.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply