Post reply

Does a Partition Switch to an empty table appear as tranlog delete?

  • December 22, 2022 at 5:45 pm

    #4129021

    i have a table that has been partition by month and year.

    the table has CDC tracking enabled on it, and a program called HVR is being used to read the transaction logs for tables using CDC for changes. it sends the changes to parquet files, where we can consume that data elsewhere.

    if we use a partition switch to swap an empty table, and thus remove a months worth of data, would that show up in the transaction log as deletes for all those month/year records?

    The idea here is we don't want to send DELETES to HVR via the transaction log downstream, so we just maintain the last x months in the database.

  • December 22, 2022 at 7:30 pm

    #4129049

    from what is defined on this manual (you did read it didn't you?) it will not add entries to the log - furthermore you need to explicitly set CDC to allow the switching (again from the manual you read).

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply