Hello, I have to implement a project for identifying and cleaning orphaned data/foreign key violated data and dupicate data. I want to automate this instead of writing manual scripts for all this. Is there are any way we can achieve this or any tool in market which can fulfill my requirement. Please suggest .
Hi I think you would have to write customized queries for your tables and use that as a sql job which would run daily, weekly or as when you require. Orphand data or foreign key violated data - You can always write a query to find it out by querying those foreign key records that dont exist in parent table. Similarly you could write a query to find out duplicate data or may be delete that. If you want help in writing queries, you could post the ddl statements of suspected tables. Hope this helps