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

• BobbyTables

  SSC-Addicted

  Points: 493

  More actions

  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.

• frederico_fonseca

  SSCoach

  Points: 16237

  More actions

  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).