[#QB-1610] Restore(.bat|.sh) argument to disable clearing of tables

QuickBuild

Restore(.bat|.sh) argument to disable clearing of tables

Created: 22/Apr/13 05:18 PM Updated: 22/Apr/13 11:37 PM

Component/s:

None

Affects Version/s:

None

Fix Version/s:

None

Original Estimate:

Unknown

Remaining Estimate:

Unknown

Time Spent:

Unknown

Description

« Hide

When doing a backup from the Administration tab you can choose to exclude Builds, Measurements and Audits.

If you execute restore(.sh|.bat) and pass the .zip file that was generated from such a backup, then the Build, Measurement and Audit data on the server get's deleted.

In some situations that is the desired outcome.

In other situations, it's important that the existing Build, Measurement and Audit data does not get deleted (cleared) when restoring a backup .zip file that does not contain Build, Measurement and Audit data.

For this improvement request I would like to ask that an additional argument be added to the Restore(.sh|.bat) to control the clearing of Build, Measurement and Audit data when it does not exist in the .zip file.

Something like:

restore.bat D:\temp\backup.zip - Would delete data when it is not contained in the backup.zip file.
restore.bat --noclear D:\temp\backup.zip - Would NOT delete data when it is not contained in the backup.zip file.

All

Comments

Work Log

Change History

Sort Order:

[ Permlink | « Hide ]

Robin Shen [22/Apr/13 11:37 PM]

This is dangerous to not restoring the database as a whole from backup since schema of existing build/audit/measurement tables might be inconsistent from other tables resulting from restore. This is the reason why we do not do that way.

Change by Robin Shen [22/Apr/13 11:37 PM]
Field	Original Value	New Value
Status	Open [ 1 ]	Closed [ 6 ]
Resolution		Won't Fix [ 2 ]