Repository Updates

Question

Hi,
if I use the Oslo Repository and SQL Server 2008 R2 with .Net 4.0 Beta 1 is it possible to get a notification if some model-data changes? Perhaps changes could be from another program or another user?

Thanks for the answer.

Answer 1

Since your model-data is in SQL, you can leverage SQL triggers to let you know when something gets deleted, inserted, modified... This can in turn create logs that will give you the specifics on the change.

Hope this helps,
-Jaime.

---

-Jaime.

Answer 2

There are a variety of mechanisms to choose from and it depends a little on what kinds of changes you are interested in (e.g. schema changes or data changes). I am guessing you are interested in data changes and being alerted via, say, email.

The repository is designed to work with Change Data Capture (CDC) and Change Tracking. CDC is an Enterprise feature that gives detailed change information while Change Tracking gives less detailed information but works on all SKUs. This lets you query for changes that have happened in a variety of interesting ways. The current plan is that all relevant schemas will support both CDC and Change Tracking.

Since the repository schemas have a straightforward relational structure, it is possible to use Reporting Services over the repository to deliver reports via email or other custom means. Essentially, a user would subscribe to change reports for data they are interested in.

Finally it is possible to write a job that queries for changes (using CDC or Change Tracking) and delivers change events via Service Broker or SSIS.

Answer 3

Hi,
thanks for the replys. Yes I want to get a notify about data changes, but i want to notify a program at realtime, perhaps beeing alert via an .Net-Event. Do you think it's possible with CDC or Change Tracking (I don't know the technology s).

Thanks for your answers