0

I am using Visual Studio 2012 and trying to run a schema compare using the SQL tools.

The only difference between databases is the addition of a column for one table. When I go to generate the script, it is only giving me an ALTER statement, not a CREATE-COPY-DROP-RENAME script.

Is there a setting that enables schema compare to be able to do this?

mr.Reband
  • 2,434
  • 2
  • 17
  • 22
RJP
  • 4,016
  • 5
  • 29
  • 42
  • You really *want* to perform all that extra work just to add a column to a table? Why? – Aaron Bertrand Aug 08 '13 at 21:35
  • Because the table has a lot of data and the new column is necessary. – RJP Aug 08 '13 at 21:36
  • 1
    Still don't understand why making a copy of the data - especially if there is a lot of it - is better? Why not take the alter statement and first make it nullable, then update the values in batches, then change it to not nullable? – Aaron Bertrand Aug 08 '13 at 21:37
  • Nevermind, I see what your saying. I had a complete blackout for a while.I just added the column with a default value. – RJP Aug 12 '13 at 13:41

0 Answers0