Synchronizating with new NOT NULL columns

mihiesmihies Posts: 71 Bronze 4
edited December 20, 2006 11:03AM in SQL Compare Previous Versions
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?
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
Blog:http://blog.rthand.com
Righthand .net consulting and software development
http://www.rthand.com

Comments

  • Eddie DEddie D Posts: 1,800 Rose Gold 5
    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 Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • mihiesmihies Posts: 71 Bronze 4
    Hi Eddie,

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

    Thanks,
    Miha Markic [MVP C#, INETA Country Leader for Slovenia]
    Blog:http://blog.rthand.com
    Righthand .net consulting and software development
    http://www.rthand.com
Sign In or Register to comment.