Luca Ritossa Blog

Do you use Microsoft Visual Studio SQL Database Project?
Do you need to rename all columns of a table? (ok, it's a rare operation).

Please pay a lot of attention because deploy and schema compare functions don't warn you that the table will be dropped and recreated... with a completely data loss!!!

This strange and dangerous behavior doesn't happen when you rename less columns.

The work-around is to manually add sql script to "copy and paste" the datas from old to new table.

- Posted using my iPhone