August 13, 2012 at 9:07 am
I like using SSMS Solutions / Projects, but there is one aspect of it that drives me crazy, and I'm hoping that someone has a solution for it.
I like to have all of my scripts, etc. in one location. However, when you add the script to a project, it copies the file into the project's directory. This leaves me with two copies of the file.
If I don't remember to go look for the file in the project directory (but instead in the directory where I store my scripts), then I end up with an out-of-date script.
I know that I can edit the project's xml file (ssmssqlproj) to include the specific path for the script, and it then uses that from then on. However, this needs to be done for each file, and whenever I add a script
Is there any setting that can be made that when a script is added to a project, that instead of copying the file, it just adds the section to the project for the file in the current location?
Or am I out of luck?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 13, 2012 at 9:16 am
Why not just create the solution/project in your scripts folder in the first place, then your project folder and scripts folder are one and the same?
August 13, 2012 at 10:29 am
'Cause that's too easy???
Seriously, thanks. It was so obvious. I thought I had ran into problems doing this in the past, but it seems to be working okay right now.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply