Performing Sync

Executing Sync

Once the configuration script has been executed and the JSON & SQL files generated, the next step is to perform the actual data sync.

You can perform the sync via the Command Prompt or the PowerShell ISE

Command Prompt

• Open a command prompt with ‘run as administrator’ privileges
• Navigate to SmartsheetToSQL folder where the scripts are located
• Enter the following command powershell.exe .\SmartsheetToSQL.ps1 -SmartsheetId [SheetID] and press <Enter> [Note: Replace the [SheetID] value with the ID of the sheet you want to sync. This will be the same sheet ID you used during the configuration process]
• Script will report sync process

PowerShell ISE

• Open PowerShell ISE application if not already open
• Open the SmartsheetToSQL.ps1 file using the File > Open menu item
• In the Script Pane window, enter .\SmartsheetToSQL.ps1 -SmartsheetId [SheetID] at the command prompt [Note: Replace the [SheetID] value with the ID of the sheet you want to sync. This will be the same sheet ID you used during the configuration process]
• Script will report sync process