Page History
After reviewing the schema compare results, select objects for synchronization, then click click and complete the synchronization process in the following order.
...
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.
Configure Script Issues
...
- If the target column contains more data than the source column, then data truncation might happen from the target column.
- 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.
...
Data type must be converted in this column
...
- 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
...
You can retain the constant value generated by Schema Synchronization or specify a new custom value for a NOT NULL column. Schema Synchronization will add the custom value as the constant value for a NOT NULL column in the deployment script and will display a Constant value will be assigned warning in the Warnings tab. This warning means Schema Synchronization generated or a new constant value will be added for the NOT NULL 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
...
You can retain the data conversion function generated by Schema Synchronization or specify a new data conversion function for the target column. Schema Synchronization will display a Column precision or data loss warning in the Warnings tab. This warning means if the data type range or the data type precision of the target column exceeded the source column then there is a possibility of deployment script failure or data loss from the target column.
...
If you choose the Ignore issue option, Schema Synchronization will add the target column name in the deployment script, instead of the data conversion function and will generate anArithmetic overflow will occur warning in the Warnings tab. This warning means if the data type range or the data type precision of the target column exceeded the data type range or the data type precision of the source column, the deployment script might fail.
When you execute the deployment script, the following happens:
- 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
Grants for missing role cannot be deployed
...
- If you skip this issue, Schema Synchronization does not generate the deployment script for the missing role.
- If you ignore this issue, you will see the Grants for missing role warning in the Warnings tab.
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 skip this issue, Schema Synchronization does not generate the deployment script for the missing user.
- If you ignore this issue, you will see the Grants for missing user warning in the Warnings tab.
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 skip this issue, Schema Synchronization does not generate the deployment script for the missing grantee.
- If you ignore this issue, you will see the Grants on missing grantees warning in the Warnings tab.
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 skip this issue, Schema Synchronization does not generate the deployment script for the missing group.
- If you ignore this issue, you will see the Grants for missing group warning in the Warnings tab.
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
You see actions and modifications that Schema Synchronization will perform on the objects of the target schema. You can view these actions in different groups by selecting an option from the View by drop-down list.
...
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 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.
...