Back to Materialize

Before You Begin

doc/user/layouts/shortcodes/sql-server-direct/before-you-begin.html

123668 B
Original Source
  • Make sure you are running SQL Server 2016 or higher with Change Data Capture (CDC) support. Materialize uses Change Data Capture which is not readily available on older versions of SQL Server. - Ensure you have access to your SQL Server instance via the sqlcmd client, or your preferred SQL client. - Ensure SQL Server Agent is running. mzsql USE msdb; SELECT servicename, status_desc, startup_type_desc FROM sys.dm_server_services WHERE servicename LIKE 'SQL Server Agent%';