My need: I have setup a scenario to test posting of transactions. Once they are posted, it cannot be undone. So, in order to test multiple times, I have been using a snapshot. However, restoring a snapshot is pretty tedious and time consuming.
I have SQL installed locally. Doing a backup via SQL takes mere seconds. Restoring a db via SQL takes seconds.
In the past, I tried restoring a sql db and it corrupted my instance of Acumatica so badly, I had to delete everything and install from scratch. I think it might have been because I was logged into the instance when I did the restore, but I don’t know what happened.
Before I kill my environment, I want to know if any of you use SQL backup/restore to perform repetitive testing.
This is what I think *should* work.
- Prepare my transactions for posting
- log out
- do a FULL sql backup
- post and look at the results.
- restore the db
- start over at step 4.
Any thoughts on this?
Best answer by Joe SchmuckerView original