Devart Forums

I am trialling Review Assistant at present. We use VS2013 with TFS. The integration with TFS seems to be working OK, I have been able to set up a project that connects to TFS OK, and I can create reviews from a number of changesets (via the "View History" page for the relevant branch).

I then tried to create a review from a work item. The work item has a number of changesets associated with it, which I can view under the "Links" tab when viewing the work item. However, if I right click on the work item and select "Review Work Item Code" nothing appears to happen. No review is created. There are no errors shown, nor are any errors logged in the event log. I have tried this with a few different work items, but the result is always the same.

Any ideas?

EDIT:

This seems to be related to having more than one changeset associated with a work item. I found a work item with a single changeset associated with it. I was able to create a review from this by right clicking and selecting "Review Work Item Code". I then cancelled the review, made a small code change and committed this, with the commit associated with the same work item. I then tried again to create a review from the work item (which now has two changesets associated with it), but this time the review was not created.

Is it possible to use the sqlite3 command utility to backup a database while the "Devart Review Assistant" service is running?

e.g.

sqlite3 reviewassistant.db

SQLite> .backup reviewassistant_backup.db

EDIT:

I've been playing around with this, it seems to work. I was able to restore the reviewassistant.db from a backup while the "DevArt Review Assistant" service was running on my local trial copy. I didn't try it on a server, but I believe the sqlite3 .restore command should handle locks etc.

I tried the following to automate the backup:

1) Download Sqlite3.exe from https://sqlite.org/download.html

2) Copy the sqlite3.exe to the same folder as reviewassistant.db (e.g C:\ProgramData\Devart\Review Assistant)

3) Create a batch file called RunBackup.bat in the same folder

4) Add the following two lines to the batch file:
sqlite3 reviewassistant.db ".backup reviewassistant_backup.db"
if exist reviewassistant_backup.db ren "reviewassistant_backup.db" "reviewassistant_backup_%date:/=-%_%time::=-%.db"

Now if RunBackup is run (either from command line or as a scheduled task) a backup file will be created with the date/time stamp in it (so multiple backups can be kept).

To restore a backup, first rename the relevant backup file from reviewassistant)backup_date_time.db to reviewassistant_backup.db (this is important, if the filename does not match that used to create the backup, the restore fails). From a command prompt enter:
sqlite3 reviewassistant.db

This will open the reviewassistant database in sqlite3. At the sqlite3 prompt, enter:
.restore reviewassistant_backup.db

Then exit sqlite3 by typing .quit