Comments
Sort by recent activity
I have seen this case happen when I've selected just one object that only I have been working on, so I don't think it's a case of selecting other people's changes. / comments
I have seen this case happen when I've selected just one object that only I have been working on, so I don't think it's a case of selecting other people's changes.
Unlinking and relinking the database seems to have solved the problem. Let me know if you'd like the log file to investigate further. / comments
Unlinking and relinking the database seems to have solved the problem. Let me know if you'd like the log file to investigate further.
I wonder how you propose to handle data changes with the dedicated model. For example, consider a case where I update my database to change the name of a column from "LocalTime" to "UTCTime". At the same time, I run a script to update all existing rows to add 8 hours. SQL Source Control will notice the name of the column has changed, and will check in that change to source control. But when other developers get my changes, they'll only get the column name change, not the data update. Similar examples include moving a column from one table to another (while preserving data). A similar issue would exist when adding a non-nullable column (with no default) to a table - in that case the update to the other dev databases would likely just fail. There are even some cases where the change involves no schema change - for example, stripping out trailing spaces from all rows of a table.
I realize that these problems aren't new - they exist even with the shared model when you need to take your changes from Dev to Test. But with the dedicated model, it seems that the problem is made worse because now you have so many copies of Dev databases that need updating.
It seems like a possible fix would be the ability to attach update scripts along with the schema changes, but even then you have problems with proper ordering, etc.
I realize this is a difficult problem to solve, but I wonder what your suggestions, thoughts, or best practices are on this matter. / comments
I wonder how you propose to handle data changes with the dedicated model. For example, consider a case where I update my database to change the name of a column from "LocalTime" to "UTCTime". At ...
Simon,
Your workaround appears to have worked perfectly, and all is working again.
Thank you,
Wesley / comments
Simon,
Your workaround appears to have worked perfectly, and all is working again.
Thank you,
Wesley