Visual Studio
How to change the path/move a project in Visual Studio
Close the solution. Rename the folders outside Visual Studio. Open the solution, ignoring the warnings. Go through all unavailable projects. Set the property ‘File Path’ to the new location. Reload the project. In case you didn’t rename the project, rename it (F2). Taken from here: http://stackoverflow.com/questions/211241/how-do-i-rename-a-project-folder-from-within-visual-studio
Regular expressions in Visual Studio
Here is a list of regular expressions that work for me in Visual Studio when locating/replacing text in SQL. generate scripts tasks for data will turn dates in to HEX. For example, it will turn a row_created_data column into CAST(0x000063DF01035C97 AS DateTime). I want to change those dates to GETDATE(): search for ‘CAST\(0x:h AS DateTime\)’ [...]