It would take a little effort, but using a combination of triggers and the service broker you can capture inserts/updates/deletes and fire async messages to store the data in a separate database, or even SQL instance.
From your "CDC" database you can then process your change data and do whatever you like with it, including running an ETL process against it for populating a Data Warehouse.
.
social.technet.microsoft.com/Forums
No comments:
Post a Comment