Recovery tables do not set defaults on not null columns
Is there a setting that will tell the compare to set a default on 'NOT NULL' columns ?
When i run sqlcompare that creates the scripts there are times when a recovery table is needed. When the recovery table is created it should set an assumed default on 'NOT NULL' columns. Otherwise the script will fail on NOT NULL columns.
Is there a setting for this situation ?
What is your recommendation for resolution ?