Transaction deletion will only delete transaction recorded previously, but wont delete the master list such as part nos, Lot no, etc.
But by creating new database, means you have to redo all the things from the start.
Just like re-implement the system.
You must scan the barcode, input all the master list, beginning balance & outstanding orders.