Wiki Admin

Capture from SQL Server using Database Triggers - DSS 6 | Data Source Solutions Documentation

Export as HTML Export as PDF Export as DOCX
Edit

Documentation: Capture from SQL Server using Database Triggers - DSS 6 | Data Source Solutions Documentation

Capture From SQL Server Using Database Triggers

<b>Since</b> 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), Data Source Solutions DSS capture changes through DBMS triggers generated by DSS 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 DSS database User must be a database owner (db_owner role).