Each deployment from the SQL development page generates a new draft version. You can compare, roll back, pin, or delete draft versions.
Background information
Draft versions support the following operations:
Compare draft versions
You can compare only SQL code and draft configurations. Differences are highlighted.
-
Log on to the Realtime Compute console.
-
Find the target workspace and click Console in the Actions column.
-
In the left-side navigation pane, click .
-
Double-click the name of the target draft.
-
On the right side of the page, click Version Information.
-
In the Actions column for the target version, click Compare.
-
In the Select Version section on the left, select the version to compare.
The system displays a side-by-side diff of the Current Editing Version and the Comparison Version, with differences highlighted in yellow. In the upper-right corner, click Rollback to revert to the selected version, or Delete to remove it.
Roll back draft versions
Roll back the current draft to a previously published version. This replaces your current draft content with the selected version.
-
Log on to the Realtime Compute console.
-
Find the target workspace and click Console in the Actions column.
-
In the left-side navigation pane, click .
-
Double-click the name of the target draft.
-
On the right side of the page, click Version Information.
-
In the Actions column for the target version, choose .
-
In the dialog box that appears, click Rollback.
The Draft Version dialog box shows the Current Editing Version on the left and the Comparison Version on the right, with differences highlighted.
Pin draft versions
The system retains up to 50 draft versions and automatically deletes the oldest when the limit is exceeded. Pin a version to prevent automatic deletion.
-
Log on to the Realtime Compute console.
-
Find the target workspace and click Console in the Actions column.
-
In the left-side navigation pane, click .
-
Double-click the name of the target draft.
-
On the right side of the page, click Version Information.
-
In the Actions column for the target version, choose .
A success message appears at the top of the page, and a
icon appears next to the version number.NotePinned versions cannot be deleted. You must unpin a version before you can delete it. To unpin a version, choose .
Delete draft versions
Delete draft versions that are no longer needed.
-
Log on to the Realtime Compute console.
-
Find the target workspace and click Console in the Actions column.
-
In the left-side navigation pane, click .
-
Double-click the name of the target draft.
-
On the right side of the page, click Version Information.
-
In the Actions column for the target version, choose .
-
In the dialog box that appears, click Delete.