Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-941

Initial snapshot using snapshot isolation level

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Done
    • Icon: Major Major
    • 0.9.0.Beta1
    • None
    • sqlserver-connector
    • None

      SQL Server supports SNAPSHOT isolation level (it has to be enabled by DBA), which seems to be a perfect match for the initial snapshot step, since it provides consistency and does not block other users' writes and reads.

      The only limitation is the fact that schema changes done during the snapshot may cause the snapshot failure.

            grzegorz.kolakowski Grzegorz Kołakowski (Inactive)
            grzegorz.kolakowski Grzegorz Kołakowski (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: