Change Data Capture Helper


Technical details
You can read

This is program is a Change Data Capture(CDC) Helper. It is wrote mainly of two reasons:
Having a GUI for CDC
Contest Sql Heroes


The main functions of the program:
Enables Change Data Capture on table bases - by trying to enable CDC on a table
Verifying SQL Server version and, if OK (>=2008) starting SQL Server Agent if stopped
Enabling the database for CDC
Enabling CDC on selected table
Disables CDC on table
Lists the CDC modification on table - and saves to Excel/Adobe/prints with Report Viewer
Restores table to a previous data
Known limitations
Enables CDC only on tables that have PK identity


There are 2 primary GUI - one for PowerShell and one for Windows The Gui for Windows is pretty simple

You can connect to a server, then to a database. Then by clicking a table it allows you to change CDC and/or to see the modifications.
Please take into account "Create Test Table" button. It creates a test table ,inserts 1 row, enables CDC on this table, make some modifications in order to ensure show the functionality of this program.
The restore data button creates a new table that restores data to the moment selected in the grid
The print data button shows you the report with changes that you can easily print or save to Excel/PDF.
For the powershell I invite you to read How to connect in Powershell
Technical details

The project is made with VS.NET Standard in .NET 3.5, in order to allow easy extend of the SQL Server Objects - that are otherwise sealed.
The project is organized in
one dll that extends the SQL Server Object (server, database, table) with CDC methods
Windows GUI
Powershell dll
Main improvements in final version
Read/Modify the cleanup date
Pre-fetch CDC for tables
Ensure proper way to verify SQL Server Agent is starting.Now reads from SQL Server processes and starts from services...
Exception for non-administrator roles
You can contact me at ignatandrei.gif

Last edited May 28, 2008 at 2:51 AM by ignatandrei, version 3