[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 the "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 this company file has been used by QODBC, 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 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 below steps.
( ONLY IF YOU WOULD LIKE TO SCHEDULE OR CREATE A BAT TO QUICKLY RUN OPTIMIZER FOR SELECTED/MULTIPLE TABLES)
In the below example, we are achieving it by created 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 and saving it to e:\ and naming it as OptimizeSelected.vbs
( you may change the name and drive location of your choice, Please do 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