CODEWITHSUNDEEP
c#loggingsql-server-2012synchronizationsql-server-ce
You
You

Reputation: 97

Keep track of synchronization changes

I have a SQL Server 2012 storing one shared database over multiple SQL Server CE database clients.

Process is like this:

  1. At application start, clients connect to server to get data from the server
  2. Clients alter the data (add new rows, modifying or deleting existing rows)
  3. Sync' with the server to send the changes

For history record, I am looking for ways to log all this activity in order to keep track of every action for maintenance sake.

How can we manage this?

Upvotes: 0

Views: 140

Answers (1)

ErikEJ
ErikEJ

Reputation: 41769

You could add an audit table and audit and log activity in your data acces layer on the client, and sync this table up.

Upvotes: 1

Related Questions