Schema Migration Rollback Behavior Unclear in NPSs

The goal is to guarantee rollback safety after applying a schema change with NPSs’ migration tool. The tool applies scripted DDL statements and logs each step, but the documentation does not specify whether the changes are wrapped in a transaction that can be automatically rolled back if an error occurs.

Current constraints include: the migration log shows individual DDL entries but no explicit BEGIN/COMMIT blocks; the documentation mentions a "rollback" option without providing example scripts or an API reference; and there is no dedicated rollback wizard in the current release notes.

Given these gaps, the unresolved decision is whether the migration tool can automatically revert all changes on failure, and if so, how that behavior is invoked or configured.

Specific questions:

• Are all DDL statements executed within a single transaction that can be committed or rolled back atomically?
• Does the "rollback" option perform a full undo of the migration steps if a failure is detected, and how is this triggered?
• Is there an API or command-line flag that enables automatic rollback during migration execution?