Capture From SQL Server Using Database Triggers

Since v6.1.0/3

The trigger-based capture method (Capture_Method=DB_TRIGGER) has been deprecated since 6.2.0/0.

In this capture method (Capture_Method=DB_TRIGGER), Fivetran HVR capture changes through DBMS triggers generated by HVR instead of using log-based capture.

Grants for Trigger-Based Capture

This section lists the grants required for capturing changes from SQL Server database using database triggers.

• The HVR database User must be a database owner (db_owner role).