reading
You Should Read
archives
- September 2004
- October 2004
- November 2004
- December 2004
- January 2005
- April 2005
- May 2005
- June 2005
- July 2005
- August 2005
- September 2005
- October 2005
- November 2005
- December 2005
- January 2006
- February 2006
- March 2006
- April 2006
- May 2006
- June 2006
- July 2006
- August 2006
- September 2006
blogs I read
- Caspian Arts
- Coding Horror
- ComputerZen
- Joel On Software
- Knowing.net
- MSBuild Team Blog
- Rob Howard
- ScottGu
- Scott On Writting
- Signal vs. Noise
- SimpleBits Articles
Wednesday, August 17, 2005
Visual Studio Database Projects and Command Files
Database Projects in Visual Studio .NET (Good primer by Scott Mitchell)
Visual Studio.NET Database Projects (Excellent in-depth article by Jeffrey McManus and Jackie Goldstein)
After reading the above articles you will learn about creating command (.cmd) files. These files will make your life easier by allowing you to execute one file to complete all of your SQL Server database updates. Unfortunately, if you are using Visual Studio 2005, you will also learn that the "Create Command File" function is now missing from the IDE. You can learn more about this and see an example .cmd file by visiting this blog posting by Kirk Marple.
Using example .cmd file content from both Jefferey McManus and Kirk Marple, as well as well as the osql Utility syntax page, I was able to create my own .cmd file.
Pay careful attention to the line that calls osql. Example:
osql -S %1 -d %2 -U myUsername -P myPassword -b -i "BS_Application_Part1.sql"
Notice that I replace -E (trusted connection) option with -U (username) and -P (password).
Content copyright ©2003-2006 Tod Birdsall
Visual Studio.NET Database Projects (Excellent in-depth article by Jeffrey McManus and Jackie Goldstein)
After reading the above articles you will learn about creating command (.cmd) files. These files will make your life easier by allowing you to execute one file to complete all of your SQL Server database updates. Unfortunately, if you are using Visual Studio 2005, you will also learn that the "Create Command File" function is now missing from the IDE. You can learn more about this and see an example .cmd file by visiting this blog posting by Kirk Marple.
Using example .cmd file content from both Jefferey McManus and Kirk Marple, as well as well as the osql Utility syntax page, I was able to create my own .cmd file.
Pay careful attention to the line that calls osql. Example:
osql -S %1 -d %2 -U myUsername -P myPassword -b -i "BS_Application_Part1.sql"
Notice that I replace -E (trusted connection) option with -U (username) and -P (password).