How can we help you today? How can we help you today?

Synchronizating with new NOT NULL columns

Hi guys,

If I add a NOT NULL column without a default value (I want application layer to generate the value) I can't synchronize database if there is any data in target table (it can't insert null values). Thats reasonable but not perfect.

I was thinking that I could enter a default value at synchronization time (into SQL Compare) and just for synchronization.
This would be a nice improvement for me...

What do you say?
mihies
0

Comments

2 comments

Sort by
  • Eddie D
    Hi Mihies

    Thank you for your suggestion.

    As you have already found if you add a NOT NULL column to a table that already contains data the synchronization fails if you do not set a default value.

    I will submit your suggestion forward but I cannot guarantee that your suggestion will appear in later versions of software.

    Best Regards
    Eddie Davis
    Red Gate Software Ltd
    Technical Support Engineer
    Eddie D
    0
  • mihies
    Hi Eddie,

    I hope you'll add it. Otherwise is a hassle dealing with such cases.

    Thanks,
    mihies
    0

Add comment

Please sign in to leave a comment.