SQL dataBase Script Using ASP.NET (SSIS, JOB)

See more:

ASP.NET

SQL-Server

SSIS

dtsearch

Hi,
I have winform (Windows) application inside that i have to implement Work offline functionality.i.e.there is central database each user is connected to that db when he is online ,now suppose he wish to work offline then once he has clicked on the Work Offline then whatever data is residing on the central server should be get transfer to local database(on his local system) i.e.(append if local db is present, other wise create the new database on local system and transfer all data from Central server to Local Db)

So that he can work with his local database when user is out of office,
once he is back whatever work he has done while offline, that should be again updated in Central database as an when he click go online.



Please share me the best approaches

Thanks in advance..