Defining Project Variables

To define one or more project variables, simply select Project->Variables from the menu or right click on the project name in the navigation pane on the left and select Variables

The following screen is then presented showing the current list of variables that have been defined for this project.

To add a new variable, click on the New button on the right of the screen, then enter the variable name and type in the fields on the left and click Add.

The variable type can be Boolean, Currency, Date, Date-Time, Decimal, Integer, String or Time.

To update an existing variable, select the corresponding row from the table, then change the variable name or type using the fields on the left, then click Update.

To remove an existing variable, select the corresponding row from the table, then click on the Remove button on the right.

Note that if a variable is currently referenced in an expression, it cannot be renamed or removed.

Variable values can be set for each execution as part of the Execution Options (See Execution Options Articles)

LAST_EXECUTION_TIMESTAMP Variable

This is a special variable that can be used in expressions by selecting the checkbox ‘Include Last Execution Timestamp’.  This special variable is updated by Precision Bridge each time the project is executed. Once Execution completes sucessfully, the variable is set to the date/time when the execution staryed. This is particularly useful for 'Delta' migrations, where a query is needed to migrate all records that were created or updates since the last execution.

CURRENT_EXECUTION_TIMESTAMP Variable

This variable will not be seen in the list (since it is not editable) but will be available to use in the project. See this article for more information.

Related Articles

Project Variables Overview

Defining Project Variable Values

CURRENT_EXECUTION_TIMESTAMP Variable