[QODBC-ALL] How to execute SP_OPTIMIZEUPDATESYNC or SP_OPTIMIZEFULLSYNC for Selected Tables
Posted by Rajendra Dewani (QODBC Support) on 05 October 2012 03:20 PM
There are multiple ways to execute SP_OPTIMIZEUPDATESYNC or SP_OPTIMIZEFULLSYNC for selected/multiple tables.
For a Single Execution, follow the below steps.
Click on "Start" and "Programs" and locate QODBC Driver for the QuickBooks program group. Click on the QODBC Test Tool icon to launch the program supplied with QODBC.
To establish a connection, select "QuickBooks Data" -> DSN from the dropdown list and click on "Connect."
This will connect you to the current company file opened by QuickBooks. After you click Connect, if this is the first time QODBC has used this company file, you will receive a popup from QuickBooks asking you to allow QODBC to run. Choose the Yes, Always option, and check the Sensitive data option.
Once you are connected, type SP_OPTIMIZEUPDATESYNC or SP_OPTIMIZEFULLSYNC and Click on "Run."
After execution, the following message will appear: "Total Number of Records 0."
For Recurring / Scheduled Execution, follow the below steps.
( ONLY IF YOU WOULD LIKE TO SCHEDULE OR CREATE A BAT TO RUN OPTIMIZER FOR SELECTED/MULTIPLE TABLES QUICKLY)
In the below example, we are achieving it by creating a VBScript.
You can create a script/exe/VBA code and execute SP_OPTIMIZEUPDATESYNC or SP_OPTIMIZEFULLSYNC for a select table.
In this example, we are creating a VBScript, saving it to e:\, and naming it OptimizeSelected.VBS
( you may change the name and drive location of your choice, please apply the same modification to the execution statement)
Below is the source of the OptimizeSelected.VBS
How to execute
For 64 bit Machine you can execute this from below command
C:\Windows\SysWOW64\cmd.exe /c cscript e:\OptimizeSelected.vbs
For 32 bit Machine you can execute this from below command
C:\Windows\System32\cmd.exe /c cscript e:\OptimizeSelected.vbs