Timeline for SQL Server and TFS - How to rename stored procedures
Current License: CC BY-SA 4.0
19 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 2, 2019 at 9:03 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Feb 24, 2019 at 9:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Aug 15, 2018 at 17:42 | comment | added | RBarryYoung | I created and attached a tag for Rename. It could get rejected by peer-review though. | |
| Aug 15, 2018 at 17:39 | history | edited | RBarryYoung |
edited tags
|
|
| Aug 15, 2018 at 15:17 | answer | added | Elaskanator | timeline score: 1 | |
| Aug 14, 2018 at 20:36 | comment | added | Elaskanator | @DanGuzman, Refactor > Rename may work in one branch, but it does not address the issue I have trying to merge the renames across branches. | |
| Jun 20, 2018 at 17:11 | comment | added | Elaskanator | I was forced into disabling IntelliSense because there must be something about how I interact with VS/SSMS that causes it to become corrupted over time (stackoverflow.com/questions/42301772). It's just 100% broken for JavaScript too even starting fresh. I'll have to try out @DanGuzman's suggestion. | |
| Jun 19, 2018 at 16:36 | comment | added | Ali Razeghi - AWS | Great clarification/explanation, thanks. Guzman is usually right on the money, I'm curious about your thoughts on his solution | |
| Jun 19, 2018 at 3:11 | comment | added | Dan Guzman | @Elaskanator, right-click on the object name in the DDL source code of your SSDT project and select Refactor-->Rename. That will rename the object, update references, and save the refactor log so it is recognized as a rename operation during deployments. | |
| Jun 18, 2018 at 18:39 | comment | added | Elaskanator | @AliRazeghi The bugged behavior of the TFS power tools when merging my changes effects the same thing as your proposal. It is important to uphold the revision tracking in TFS, so it needs to treat the change as a rename instead of a delete and a separate add, since the added file will not have any link to the past history that just got deleted with the old file. | |
| Jun 18, 2018 at 18:25 | comment | added | Ali Razeghi - AWS | I don't want to sound like a n00b here but what if you just create new stored procedures with the proper names, then depreciate the old one upon careful review of the code? Pardon I haven't done too much of TFS so I'm not sure if this is viable. | |
| Jun 18, 2018 at 17:19 | history | edited | Elaskanator | CC BY-SA 4.0 |
added 44 characters in body
|
| Jun 18, 2018 at 16:04 | comment | added | Erik Reasonable Rates Darling | Cool, best of luck with TFS! | |
| Jun 18, 2018 at 16:01 | comment | added | Elaskanator | Also to quote the MSDN you linked to: "Renaming an object such as a table or column will not automatically rename references to that object. You must modify any objects that reference the renamed object manually." Therefore it is completely useless for my purpose. | |
| Jun 18, 2018 at 15:59 | history | edited | Elaskanator | CC BY-SA 4.0 |
added 110 characters in body
|
| Jun 18, 2018 at 15:57 | comment | added | Erik Reasonable Rates Darling | I wasn't suggesting it does. Just that people do often rename things in databases. | |
| Jun 18, 2018 at 15:57 | comment | added | Elaskanator | That doesn't work in TFS | |
| Jun 18, 2018 at 15:56 | comment | added | Erik Reasonable Rates Darling | Never say never ;) | |
| Jun 18, 2018 at 15:51 | history | asked | Elaskanator | CC BY-SA 4.0 |