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.