Placing Database under Source Control
I have been trying to evaluate how SQL Server Management Studio integrates with source control. The only thing I can find is the ability to place a database 'solution' under source control and that basically puts create scripts and change scripts under source control. It doesn't keep 2 or more people from making changes to the same object.
Upvotes: 2<=-=Jun 20 2008 2:27PM=-=> harolds,
Thank you for the suggestion. I will send a notification to the feature team to keep tracking of this suggestion.
Program Manager, Microsoft SQL Server
Harold is a colleague of mine. It just seems strange to us that all SQL related source control is done at a SQL script level instead of an actual object level within SQL Server itself. You should be required “check-out” a stored procedure, for example, before you can ALTER it. If you “Undo check-out” then the object should be restored to it’s previous state.