Troubleshooting: Adding NOT NULL columns to table during synchronization.

LINKS

General

Apex SQL Audit
Apex SQL Clean
Apex SQL Code
Apex SQL Diff
Apex SQL Diff (Data)
Apex SQL Doc
Apex SQL Edit
Apex SQL Enforce
Apex SQL Log
Apex SQL Report
Apex SQL Script

Troubleshooting Home

SITE FEED

Site Feed

Support Forum

The fastest and most effective to get answers to your questions quickly. Click Here for more info.

FAQs

Quick answers to common questions. Click Here for more info.

Troubleshooting

Known issues and basic troubleshooting techniques for problems or unexpected behaviors. Click Here for more info.

Knowledgebase

Technical tips, How-to articles, and other tutorials about ApexSQL Tools. Click Here for more info.

Online Documentation

All of our help files for download or convenient viewing online. Click Here for more info.

Videos

Watch product demos, training videos, or tutorials of our products' main features. We frequently upload new videos so check often for updates. Click Here for more info.

Troubleshooting

Troubleshooting and Known issues with Apex SQL Tools

Adding NOT NULL columns to table during synchronization.

SUMMARY

When it is necessary to add NOT NULL columns to the target table during synchronization the Default constraints are created automatically for each added column.

This approach allows to add columns even to the tables containing data and fill the NOT NULL columns of the altered table with "0" for each of existing row of data.
However, ApexSQL Diff doesn't drop the Default constraints after they had been added automatically and synchronized tables become different in Default constraints, and Default constraints are created with the randomly chosen names.

RESOLUTION
There are two workarounds available for this case:

Re-comparing and synchronizing the objects repeatedly.

Creating a script for dropping the extra- Defaults and execute it after synchronization script is finished:
- Edit the Post-Processing script at Script Processing step of Structure Synchronization Wizard:
- Enter script that will drop default constraints from the destination table:
- The post-processing script drops extra-Constraints after synchronization script execution is finished:

LAST REVIEW

19 September 2007 Date of Last Review

Labels: ApexSQL Diff

posted by Irene Sanford on Tuesday, July 17, 2007

0 Comments: