Tracking data update in a database

  • Our accounting package creates records in our database for invoices, credit notes......etc. I want to write an app in vb that will create one of these such documents outside of the package.Is there a way I can set something to watch the current state of the database , create a document with our accounting package and then go back into sql to see exactly what records it created and what it changed?

  • You can use Profiler, probably the easiest way for large scale tracking of things. It will record all SQL run against the database (you can limit it by user/login).

  • +1 on profiler. I use profiler all th etime to determine what vendor apps are doing. I do recommend doing this on a test server, as it's easier to isolate the data you want. On a production server, it can be difficult to capture the desired data, especially if the app uses SQL authentication, and uses a common ID for all operations.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply