Sync project

[aspfun]

I was assigning a vb.net project as descript below:
User uses laptop.
1)Most time user is off line. Need to create a “add new” form to let user input new records.
Data will sore in laptop Access mdb file or SQL express.
2)Once user use wireless to connect company server, data in laptop need to sync with SQL server:
a) download new data from ftp server to laptop (for some dictionary data)
b) upload new data from laptop which user was entered to ftp server
So far, I do not have any idea how to do the step 2)
Can someone give me an idea, resource link?

 

[jmcilhinney]

You should use SQL Server CE instead of Access on the laptop. I've never used it but you should look into the Microsoft Sync Framework, which will do what you want between SQL Server CE and SQL Server.