SQL Server schema comparison - leaves behind obsolete files on synchronization
- by b0x0rz
Directly related to http://stackoverflow.com/questions/2768489/visual-studio-2010-database-project-is-there-a-visual-way/2772205#2772205
I have a problem synchronizing between database project and a database in Visual Studio.
Usually I synchronize FROM database TO database project (using the Visual Studio data scheme compare new schema comparison).
The synchronization works, BUT when I for example corrected the spelling of a key in the database and synchronized it - the file with the WRONG spelling of a key remains (albeit is commented out inside). the new one is correctly added.
This file happens to be in:
[project name]/Scheme Objects/Schemas/dbo/Tables/Keys
But for sure there are others elsewhere.
how to automatically remove such obsolete files when synchronizing?
thnx