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?