| Uses the local Pervasive Workgroup Engine on the machine where you perform the task. | Uses the Pervasive/Actian Server Engine. | Uses the Pervasive/Actian Server Engine. |
| Copies data into temp files to perform the trial run, then removes the temp files when finished. Notes: When ran on a workstation, it creates these temp files in the local user's temp directory (C:\Users\[user]\AppData\Local\Temp). When ran on the server, it creates these temp files in the temp directory on the server (C:\Windows\Temp). | Copies data into temp files to perform the trial run, then removes the temp files when finished. Notes: When ran on a workstation, it creates these temp files inside the company data folder. When ran on the server, it creates these temp files in the temp directory on the server (C:\Windows\Temp). | Doesn’t use temp files. Uses the active ("live") data files. |
| Doesn’t create any transactions or update any data. | Doesn’t create any transactions or update any data. | Creates transactions and updates data. |