Modify SQL Server Offsets

Overview

This page explains how to modify the timestamps in multiple offsets to adjust the start time of data sync in the static mode of SQL Server CDC.

BladePipe supports two ways to modify the offsets:

• Manual way
• Interactive way

Manual Way

Original Offset

[
  {
    "db": "my_db",
    "schema": "dbo",
    "table": "my_table",
    "commitLsn": "002b083b:0002269:0008",
    "seqVal": "002b083b:00022212:0005",
    "timestamp": "1747800371676"
  }
]

If you only want to modify the data sync time, you can manually update the value in the timestamp field to the new one and change commitLsn and seqVal to null:

Modified Offset

[
  {
    "db": "my_db",
    "schema": "dbo",
    "table": "my_table",
    "commitLsn": null,
    "seqVal": null,
    "timestamp": "1747800471676"
  }
]

Interactive Way

Enter the Offset

Please enter the offset first and click "Parse".