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

              Assignee:
              grzegorzk Grzegorz Kołakowski (Inactive)
              Reporter:
              grzegorzk Grzegorz Kołakowski (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: