I don't know what your specific scenario is, hence I can't make any other constructive suggestions
It seems to me that you actually have a server with multiple clients and you want to just keep track of all changes made by the users, instead of having data
synchronized (which is what Sync Framework is doing), so it's more a simple client-server applications than a sync ecosystem.
The only option I think you can do this is to make the user insert a new row instead of modifying a certain existing row. Then maybe you can perform some regular cleanup of the database, where you move all "not the last" rows to some sort
of an archive.
Or you can implement this logic on the server side - have an update trigger, which will copy the old value to some table before writing the new value.
Other option is to search for a product which does this for you.
Hope this helps.
Adrian
