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

Initial snapshot using snapshot isolation level

    XMLWordPrintable

Details

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: