Creating the target staging schema

Before translated SQL can be tested, the target staging database must contain the same schema as defined in the current SQL Tran project. Since connections to both staging databases have already been configured, the next step is to create the required objects in the target environment.

In our example project, the target staging database is initially empty and does not yet include any of the project’s objects. To proceed with testing, we need to deploy the full schema into the target staging environment.

This page walks you through creating the target staging database schema using the Actions menu in the Overview screen.

1. Go to the Overview screen

Click the Overview button in the left sidebar to access the screen.

At this point in the process, the target staging database does not yet contain any objects from the SQL Tran project.

As a result, the Creation stage in the object lifecycle area shows zero progress. The circular overall progress indicator remains at zero percent, all progress bars for individual object types (such as tables, views, procedures, and functions) are empty, and the numeric statistics confirm that no objects have been created.

This initial state will provide a clear contrast after we perform the creation operation.

2. Open the Actions menu

In the Overview screen, open the Actions menu by clicking its dropdown button.

3. Initiate the schema creation process

From the Actions menu, under the Target staging database section, select Fully recreate all objects.

This operation will drop and then create all objects defined in the current project within the target staging database.

4. Confirm the action

A dialog titled Recreate all objects in the target staging appears.

Click the Continue button to begin the operation.

5. Track operation progress

After a brief initialization, a progress dialog is displayed. This dialog shows:

• Each step of the operation

• Real-time progress for the current step

• Relevant execution statistics

A Cancel button is available at the bottom of the dialog, allowing you to interrupt the operation if necessary.

6. Complete the operation

Once the operation has finished, SQL Tran displays a result dialog summarizing the outcome.

Each action performed during the operation is listed with a status indicator and can be clicked to expand and view additional details. This allows users to inspect the outcome of every step and identify any problems if they occurred.

Typical actions shown in this dialog include:

• Drop constraints

• Drop objects

• Create objects

• Create constraints

Click the OK button to close the dialog and return to the Overview screen.

7. Review the result

After completing the schema creation process, the Creation stage in the Overview screen reflects the updated state of the target staging database.

The circular overall progress indicator now displays the percentage of project objects successfully created, along with a numerical summary beneath it. Progress bars now reflect completion percentages for each object type.

In the next section, we will shift focus to preparing the source staging database. After setting up the schema in the target environment, it is equally important to ensure that the source staging database mirrors the same structure and includes representative data for effective testing.