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.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

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

                  Dates

                  • Created:
                    Updated:
                    Resolved: