In SQL Compare can generated scripts do 'IF EXISTS....' check before adding columns?
We are having SQL Compare generate scripts to upgrade databases. We have a fairly complicated scenario where we need to add a new not null column to a table in pre-scripts and populate the new column with scripts. RedGate is generating scripts that attempt to add the column that is already there. It would be really great if there was a way to tell RedGate to check for the columns existence before the script attempts to adding the column.
0 · Share on Twitter