@kapa.ai can you replicate data without enabling ALLOW_SNAPSHOT_ISOLATION in mssql source?

No, you cannot replicate data using the Change Data Capture (CDC) method in Airbyte without enabling

ALLOW_SNAPSHOT_ISOLATION

in the MSSQL source. This is because Airbyte uses snapshot isolation to avoid acquiring table locks when performing an initial consistent snapshot of your database during the first sync run using CDC. This allows simultaneous writes by other database clients. Here is the command to enable snapshot isolation on your database:

sql ALTER DATABASE {database name}     SET ALLOW_SNAPSHOT_ISOLATION ON;

However, if you do not want to enable snapshot isolation, you might consider using other replication methods such as Full Refresh or Incremental replication, depending on your use case and data requirements. Please note that the CDC method is particularly useful if you need a record of deletions, your data set is large, or your table has a primary key but doesn't have a reasonable cursor field for incremental syncing. For more information, you can refer to the [Airbyte MSSQL Source Documentation](https://docs.airbyte.com/integrations/sources/mssql#2-enable-snapshot-isolation) and the [Forum Post](https://discuss.airbyte.io/t/453) discussing this topic.