Object tree

Objects are grouped by type. Each object has an icon representing its type, but also a stage icon where each stage is a color-coded circle.

First circle is red if we can't parse your code. It's orange if we can parse it but there are broken references.

Second circle will be red if we can't transpile your code and green if we can.

Third circle represents the creation status in the target database. For that to be enabled, you will need to set up connection info in the project settings. If the object was not created yet, the circle will be small, gray, and hollow. If there was an error creating it, it will be red. If it was created successfully, it will be green.

All three dots being green mean you have passed all stages - the object is created in the target and can be used.

If you use tests in your project, you will see four dots instead of three, the fourth one signifying the tests for the specific object.

Object context menu

Override source

When you want to remove non-important code in the source script or make some changes while still letting SQL Tran translate your code in real-time, this is the way to achieve that.

Override target

When you want to start customizing the translated code while starting from the one SQL Tran generates, choose Override target.

Revert to original

This option removes any customizations your may have used in the source or target script and reverts both to their original values.

Object group context menu

When you click the object group, you can have a set of actions applied to the objects of that group.

Apply {group type} changes to the target database

Create group objects in the target database. Applies to only objects with target script change since originally created (or not created at all).

Recreate all {group type} in the target database

Create all group objects in the target staging database even if unchanged.

Drop all target database {group type}

Drop all group objects in the target stagingn database.

Last updated