Introduction to SQL passthrough

The SQL Passthrough feature allows you to download scripts of SQL statements from a consolidated database to a SQL Anywhere or UltraLite client, and have those SQL statements executed on the client at an appropriate time. The scripts are numbered and are guaranteed to be executed on the client in order.

After a script is executed or an attempt is made to execute it, status is sent back to the consolidated database with the next synchronization so that both successful runs and failures can be centrally monitored. When an error occurs executing a script on a client, no further scripts are executed on that client until the status has been uploaded to the consolidated database and the consolidated has downloaded instructions to the client on how to proceed. These instructions may mean retrying the existing script, skipping it, or downloading a new script to fix the error.

Below is an overview of the steps required to use SQL Passthrough:


Creating a script
Creating passthrough entries
Downloading scripts
Executing scripts
Capturing script results
Reviewing script results
Handling script errors