Skip to main content

Create User and permissions

✅ SQL Server Debezium Test — Without GO

1. Create Database


CREATE DATABASE DebeziumTest;

Switch Database


USE DebeziumTest;

✅ 2. Enable CDC on the Database

(Works without GO)


EXEC sys.sp_cdc_enable_db;

✅ 3. Create Test Table


CREATE TABLE dbo.Customers ( CustomerID INT IDENTITY(1,1) PRIMARY KEY, FirstName NVARCHAR(100), LastName NVARCHAR(100), Email NVARCHAR(255), CreatedAt DATETIME DEFAULT GETDATE() );

✅ 4. Enable CDC on the Table


EXEC sys.sp_cdc_enable_table @source_schema = 'dbo', @source_name = 'Customers', @role_name = NULL, @supports_net_changes = 0;

✅ 5. Insert Sample Data


INSERT INTO dbo.Customers (FirstName, LastName, Email) VALUES ('Golam', 'Kibria', 'golam@example.com'), ('John', 'Doe', 'john.doe@example.com'), ('Jane', 'Smith', 'jane.smith@example.com');

✅ 6. Update Data


UPDATE dbo.Customers SET Email = 'golam.kibria@updated.com' WHERE CustomerID = 1;

✅ 7. Delete Data


DELETE FROM dbo.Customers WHERE CustomerID = 2;

🔍 8. Check CDC Status


SELECT name, is_cdc_enabled FROM sys.databases WHERE name='DebeziumTest';

SELECT name, is_tracked_by_cdc FROM sys.tables WHERE name='Customers';

No comments to display

Back to top