Post reply

Alternative to cdc for Standard Edition - Output clause or Triggers?

  • August 14, 2012 at 8:16 am

    #260103

    Hi,

    I am in the need for an alternative to cdc as I am using SQL 2008 Standard Edition. I know that I can use triggers (the seemly universally hated) or I can utilse the output clause in the Sprocs, but I am after a 'view' from you guys of those two with regard to performance, or any alternatives .

    Thanks in advance

    E.

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk

  • August 14, 2012 at 8:20 am

    #1525552

    check out this project over at codeplex:

    http://standardeditioncdc.codeplex.com/

    it is a project that someone built that ads a CDC-equivilent to 2008 Standard.

    StandardCDC is a project to enable customers on Standard Edition SQL Server (2005 or above) to implement data capture in a manner conceptually equivalent to the Change Data Capture feature in SQL Server 2008 Enterprise Edition.

    StandardCDC captures data manipulation language (DML) changes for a specified table and stores the results in a relational format. The capture table mirrors the column list of the tracked object, with options for storing only specific columns.

    The following objects are created as part of the installation: Stored procedures for enabling/disabling functionality at database and table level

    Meta data tables for tracked objects

    SQL Agent job purging data on defined schedule

    DDL trigger for notification of table changes

    Schema named "utility"

    User defined function for splitting an array

    Number table (used by above function)

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • August 14, 2012 at 8:21 am

    #1525554

    Ness (8/14/2012)

    Hi,

    I am in the need for an alternative to cdc as I am using SQL 2008 Standard Edition. I know that I can use triggers (the seemly universally hated) or I can utilse the output clause in the Sprocs, but I am after a 'view' from you guys of those two with regard to performance, or any alternatives .

    Thanks in advance

    E.

    I'm not sure that a proper DML trigger is universally hated. You can google "audit triggers SQL Server" and find many resources. I know many of the experts here use these riggers and have their own scripts.

    Jared
    CE - Microsoft

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply