Hi
Scenario: In general user will take database backup from database server to local system. User perform some changes to his local database based on his requirement. Again user connects to database server and click on update, local database should update to server database by informing each record status to the user. ex: record 1 updated / call closed do you want to update?
Here local database is going to be Pocket pc database and server database is on SQLDatabase. Can any one suggest best way to implement this feature in Windows Pocket pc, c#. I would appreciate your reply.
Thanks,
Replication could be used to keep the databases syncronized.
However, with your desire for user interaction with the process, I think that you are going to have to have a custom application.
As far as I am aware, there is no 'simple' process in SQL Server that would allow "informing each record status to the user. ex: record 1 updated / call closed do you want to update". I don't think that you would want users to have access to (and permissions for), the SQL Client Tools, particularly, SSMS.
|||
No comments:
Post a Comment