How to track changes in many MSSQL databases from .NET application?
Posted
by Yauheni Sivukha
on Stack Overflow
See other posts from Stack Overflow
or by Yauheni Sivukha
Published on 2010-04-22T08:19:28Z
Indexed on
2010/04/22
8:53 UTC
Read the original article
Hit count: 407
Problem: There are a lot of different databases, which is populated by many different applications directly (without any common application layer). Data can be accessed only through SP (by policy)
Task: Application needs to track changes in these databases and react in minimal time.
Possible solutions:
1) Create trigger for each table in each database, which will populate one table with events. Application will watch this table through SqlDependency.
2) Watch each table in each database through SqlDependency.
3) Create trigger for each table in each database, which will notify application using managed extension.
Which is the best way?
© Stack Overflow or respective owner
