The Target Schema Generation page of the Schema Wizard allows you to start generation of the selected database schema or sub-schema.
The generation is asyncronious process, so that you can switch to a different document and continue working with the application while the operation is performed.
Depending on if you chose just to generate a target script file or directly deploy the generated schema to a target database, there is different set of runtime options available.
In both cases, you can specify how you want to handle errors. You can either stop at each error occurrence and display the error message, so that you could decide if you want to stop the script execution on an error-by-error basis, or allow the program to ignore errors and continue the execution. In the last case, you can view the generated error log file after the script generation or execution is completed.
If you choose to deploy the generated script on the target, you can also select the option to run the script within a multi-statement transaction when the target database supports transactions. If you select this option, you will be able to rollback the entire script in case of an error.
You can also choose to generate a script file, when you deploy the schema to a different database.
To start the operation press Start button.
To view an error log file generated during the operation, press View Errors button. The error log is formatted as SQL script file, which contains all failed SQL statements and error messages in the comment braces, so that you could just make required fixes to this file and re-execute it from the SQL Editor.