Page History
...
The Review Dependencies tab shows objects selected for deployment and the dependent objects. The dependent objects are synchronized to prevent the deployment script from failing. Objects are displayed in the Affected Objects column because these objects are referred by or refer to the objects in the Referencing Or Referenced By column. When you click a dependent object, you can view the differences between both the source and target objects in the default viewer.
If a dependent object supported in Aqua Data Studio is not supported in Schema Compare, then during deployment, Schema Synchronization will not include dependencies of this dependent object, and the deployment script will fail. To synchronize these dependencies, create the dependent object on the target server before executing the deployment script. 
From the Dependent Objects area, you can include/exclude dependent objects for synchronization. However, you cannot unselect the dependent objects that are also present in the Objects Selected For Deployment area.
We recommend deploying all dependent objects, to avoid deployment script from failing or receiving unexpected results.
You can use Search to narrow down the result. You can also copy the list of dependent objects to a different editor.
...
You can prevent data loss from the target column by mapping the target column to the correct source column.
In the Target Table Column Mapping pane, the columns are automatically mapped to Source Columns based upon data type or other attributes that are compatible with the target column. You can retain this default selection or choose a different column from the drop-down list.
To map the target column to a different column in the drop-down list, select the target column, and then from the adjacent Source Column drop-down list, choose a column to map.
Schema Synchronization will generate a Column renamed warning in the Warnings tab. This warning means Schema Synchronization will rename the target column to the source column.
When you execute the deployment script, Schema Synchronization renames the target column name to match the source column name. 
Drop Column from the Target Table
From the Source Column, if you drop the target column then Schema Synchronization will generate a Column dropped warning, which means, Schema Synchronization will drop the column from the target table. 
When you execute the deployment script, Schema Synchronization drops that column from the target table.
...
Schema Synchronization will show you this tab only if it finds issues that might require user input.
This table shows the severity for each warning that can affect the deployment script and the action you can take to resolve them.
...
- If the issue was ignored, then the possibility of deployment script failure and data loss from the target column will be high because Schema Synchronization will execute the script with the column name instead of the conversion function.
- If data of the target column is not in the correct format, then the deployment script will fail, and data loss from the target column will occur.
No value specified for a NOT NULL column
...
If you choose the Ignore issue option, Schema Synchronization will add NOT NULL for the target column and will add no value for this column in the deployment script and will display a No value specified for a NOT NULL column warning in the Warnings tab. This warning means no value is specified for the NOT NULL column.
When you execute the deployment script, the deployment script will fail only if the NULL column in the target database contains a NULL value. 
Constant value must be assigned in this column
...
If you choose the Ignore issue option, Schema Synchronization will add the constant value of a data type in the deployment script defined by Schema Synchronization itself and will display a Constant value will be assigned warning in the Warnings tab. This warning means the constant value of a data type will be added in the deployment script.
For both the above actions, when you execute the deployment script, data in the target column will be lost. 
Arithmetic overflow can occur
...
- If the target column contains more data than the source column, then data loss from the target column might occur.
- If the issue was ignored, then the possibility of deployment script failure and data loss from the target column will be high because Schema Synchronization will execute the script with the column name instead of the conversion function.
Grant Issues
...
If you execute the deployment script without creating the missing role in the target database, the deployment script will fail.
Grants for missing user cannot be deployed
...
If you execute the deployment script without creating the missing user in the target database, the deployment script will fail.
Grants on missing grantees cannot be deployed
...
If you execute the deployment script without creating the missing grantee in the target database, the deployment script will fail.
Grants for missing group cannot be deployed
...
If you execute the deployment script without creating the missing group in the target database, the deployment script will fail.
Options
Schema Synchronization will display various options that you can include or exclude from the deployment script. 
Statement Separator (All Servers)
...
This section contains information on the server-specific options.
MS SQL Server
Include Print Comments
When you select this check box, you will see a print comment for every action that Schema Synchronization will perform in the deployment script. After the deployment script is executed, you can see the comment of each action in a print command with its execution status in the Text Results Tab. 
Refresh views
...
The definition of the target view will be refreshed based on the updated target object as Schema Synchronization will add the “sp_refreshview” procedure in the deployment script. This procedure will update the definition of the target view. So, in the following example, after the script is executed, c3 and c4 columns are dropped from the target table, and the view is refreshed.
Check box unselected
The definition of the target view does not change based on the changes made to the target table and therefore the view definition will become invalid. So, in the following example, after the script is executed, c3 and c4 columns are dropped from the target table, but the view is not refreshed.
Use a Single Transaction
When you select this check box, Schema Synchronization inserts transaction statements in the deployment script. If the deployment script fails, these transaction statements allow the target server to roll back to its initial stage by reverting all modifications made from the start of the execution of the deployment script. If a single statement in the deployment script fails, the complete transaction will fail. 
Sybase ASE Server
Generate setuser
...
Schema Synchronization will display warnings encountered while creating the deployment script. The warnings are categorized as High, Medium, and Low. You can also view the changes that Schema Synchronization will make in the script under the Summary and Detail column. You can hover the mouse on any warning in the Detail column and view the entire warning description in a tooltip. For additional information on warnings, see Schema Synchronization Warnings. Besides this, you can perform various other actions, such as searching warnings by using various search options or copying warnings to a different editor. 
Summary Tab
...
Other actions you can perform in this tab are searching summary actions by using various search options and copying summary actions to a different editor.
Deployment Script Tab
In the Deployment Script tab, you see the generated SQL script to synchronize the source and target schemas. The comments above each SQL statement are the modifications that Schema Synchronization will perform on the objects of the target schema. There are various actions you can perform in this tab, such as saving the script in the .sql format on your local system, searching for DDL statements within the script, copying the script to a different editor, and collapsing the code to a single line using toggles. After you have reviewed the script, click Open Script in Query Analyzer, and then click 
, to execute the deployment script on the target schema.
We recommend backing up the target database and executing the script in the test environment before executing it in the production environment.
When you execute the deployment script, Schema Synchronization drops that column from the target table.
...