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

Initial snapshot using snapshot isolation level

    XMLWordPrintable

Details

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

    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

          is incorporated by

          Enhancement - An enhancement to or refactoring of existing functionality that is not configurable by an end user (typically a change made by an internal team that affects users) DBZ-947 Snapshot isolation level overhaul

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          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: