Is it possible to purge the data for just one instance from the repository?

sacottingsacotting Posts: 2 New member
edited May 22, 2024 12:44PM in Redgate Monitor
I have an instance that has one database that will be for production.  We are migrating an Oracle DB to SQL and have been using this instance to do dry-run testing on our migration process.  Now we are ready for go-live and I would like to purge the data for just this instance from the Redgate repository.  I have seen the documents about retention but those appear to be for all instances that are being monitored.  Is there a way to purge just one instance so that new data can be collected starting at go-live?
Thanks
Tagged:
· Share on Twitter

Answers

  • Alex BAlex B Posts: 1,158 Diamond 4
    Hi @sacotting,

    There isn't through the normal purge process, however, if you have a specific time when you are switching over and it is a single instance on a single server you can remove the server level entity (which removes the instance level entity) and tick the box to delete existing sampled data for that entity, and then re-add the entity for go-live where it will start over fresh sampling the new data. 

    Does that sound like it will meet your needs?

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
    · Share on Twitter
  • sacottingsacotting Posts: 2 New member
    Hi Alex,
    That will work for us - thanks for your response!
    Sallie
    · Share on Twitter
Sign In or Register to comment.