Deleting junk data and its ref. from whole database

VJFuturism

Hi,

Is there any tool available from RedGate to delete junk data and its ref.(cascade delete), instead of manual delete, from entire SQL database ?

Thanks in Advance,

way0utwest

We don't. Data Compare won't do this unless you select all the child tables, and had the data already removed. You can certainly turn on cascading deletes and then run your delete, and then disable this. Is there a reason you can't do this?

Or maybe I misunderstand your issue. What is the "junk data"? Is it all data?

VJFuturism

Nope, its part of data which is entered for testing purpose.

way0utwest

How would you identify this? I'm guessing you have a value in a parent tableof the PK(s) that you need to delete, but want those removed, along with cascades. Is there a reason you can't turn on cascading deletes?