We have multiple tables in transnational replication, from SQL to SQL, and version is 2012.
User wanted to truncate one table(16M Rows) and load the data newly which is part of trans replication.
And replication is configured for the same table from Prod to QA, and QA to Dev, so replication should not disturb from QA to Dev when we truncate/remove and re-add the table from prod publication
We have minimal time to do so..
Steps we know ..
1. Drop/Remove the article from Publication
2. Reinitialize subscription
3. Truncate table
4. Add the article again into replication with snapshot of single article
-- Issue is at step 2, we don't want to reinitialize the replication which will take around 5 hours .
Please suggest best approach and steps to Remove and Add same replicated table without reinitialize subscription from Prod-QA-Dev