How can we help you today? How can we help you today?

Deleting junk data and its ref. from whole database

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,
shouser
0

Comments

3 comments

Sort by
  • 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?
    way0utwest
    0
  • VJFuturism
    Nope, its part of data which is entered for testing purpose.
    VJFuturism
    0
  • 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?
    way0utwest
    0

Add comment

Please sign in to leave a comment.