[Cascavel-pm] SQL Server Change Data Capture [off-topic]

Alceu Rodrigues de Freitas Junior glasswalk3r em yahoo.com.br
Quinta Setembro 19 13:36:10 PDT 2013


Pessoal,

Alguém aí já usou o recurso Change Data Capture do SQL Server 2008?

"Change data capture is designed to capture insert, update, and delete 
activity applied to SQL Server tables, and to make the details of the 
changes available in an easily consumed relational format. The change 
tables used by change data capture contain columns that mirror the 
column structure of a tracked source table, along with the metadata 
needed to understand the changes that have occurred."

http://msdn.microsoft.com/en-us/library/bb522489%28v=sql.105%29.aspx

Será que isso funciona sem detonar o desempenho do banco?

Obrigado,
Alceu


Mais detalhes sobre a lista de discussão Cascavel-pm