Category: 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)’ (:h searches for hex...