This website stores cookies on your computer. These cookies are used to collect information about how you interact with our website and allow us to remember you. We use this information in order to improve and customize your browsing experience and for analytics and metrics about our visitors on this website. To find out more about the cookies we use, see our Privacy Policy.

HOW TO: Delete test issues from RMTrack

Summary

One of the principals of RMTrack is that issues cannot be deleted, they must be closed. However, it may be necessary to delete test issues, especially after the intital evaluation stage. For this reason we have created a set of SQL scripts that can be used to delete issues and to reset your issue numbers.

These scripts must be run from SQL Query Analyzer. If you are using MSDE please contact RMTrack Support for assistance.

Steps

  1. Download the SQL scripts and save them on your server.
    The scripts can be downloaded from: http://www.rmtrack.com/downloads/DeleteIssues.zip.
  2. Unzip the above file and save the 4 scripts somewhere accessible.
    The ZIP file contains:
    1. DeleteOneIssue.sql - Used to delete specific issues.
    2. DeleteIssuesbydate.sql - Used to delete issues older than a date.
    3. IssueIDReseed.sql - Used to set the starting Issue ID number.
    4. IssueRenumber.sql. - Used to set stating project issue numbers when you are using the site option "Number issues sequentially within projects".
  3. Consider doing a backup, as it is always a good idea to have a recent backup of the database prior to executing any SQL script.
  4. Run the desired scripts in SQL Query Analyzer.
    NOTE: Each script is documented and each script requires modifications to run. Please read the script header carefully.

Applies to

RMTrack Issue Tracking - all versions

Keywords: Delete, Numbers, Reseed