Database backup

[heyman]

Hi

How do we backup the Review Assistant database?

Heyman

[AlexeyN]

Hello,

You should stop the "Devart Review Assistant" service and then copy the database from:
"%ProgramData%\Devart\Review Assistant\reviewassistant.db"

[allev]

Hello,

You should stop the "Devart Review Assistant" service and then copy the database from:
"%ProgramData%\Devart\Review Assistant\reviewassistant.db"

Will it help to use database from trial version after purchasing?

[AlexeyN]

Database in not affected in any way, when you perform Review Assistant licensing operation.

[ima-aa]

yes but its difficult do stop the server for the daily backup. Maybe its possible to use a "real" database like ms sql, oracle, ... so we can do a online backup.

would be important to us to do a regular and easy backup of the reviews

best regards
Andreas

[AlexeyN]

We have planned a new feature - automatic creation of database backups.

[ima-aa]

thanks - that sounds nice.

But i think the best to many of us would be supporting a major database so we can set up just one backup job. also own reporting would be easier...

best regards
Andreas

[rhames]

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