sql server - How can one get visual studio to do a simple change instead of a drop/add when altering database table columns? -
simply put:
- i trying use visual studio database project update sql server database
- i change names of table columns using refactoring tool
- once column names changed schema comparison before making final changes database
- however, notice drop column who's name has been changed , re-adds (this leads data loss don't want)
- how can change settings in someway make simple change not drop/add when changing names of columns
see this renaming columns. not sure vs diff code generation, might have modify generated script yourself.
Comments
Post a Comment