• CDC is easier to setup and it is only available in SQL Server enterprise edition. CDC do not require creating triggers and storing data.

    Triggers are more flexible as user can audit server users and applications etc. Triggers require more planning and management to design triggers and how to store them.