We have a situation where we would like to delete from multiple tables (60-70 tables) and keep data from only 2 years and current financial year . They all are very large (millions of rows).
Based on date from one table we need to find appropriate ID value from all 60-70 tables.
ID is the PK in all tables. In additional, data are replicated through replication.
What would be the best way to delete the records from all tables without affecting replication?
Thanks in advance.
Well, replication throws a wrench in what I would consider unless it is something you could tear down and rebuild.
Regarding the deletion of data my first question is to ask what is the ration of data being kept to data being deleted. That alone will have an impact in how you approach the task.