One big advantage over recent database projects is the ability to do headless build on a build controller.   There is no straight forward definition of a headless build. In summary you can describe it that only the needed prerequisites are installed for compiling and translating the bits...

Some of us might be still bound to VSDBCMD instead of using the new tools of SSDT like SQLPackage. As frustrating as it is, we need to also get around this and the limitations of the existing error Messages of VSDBCMD. The one you will encounter often is: The database schema provider could not be determined...

(Updated version available here) As suggested by M Merrill in my former post of SQLCMDScriptExpander (which can be found here ), I added an option for providing the encoding of files. So I created another option where you can specify the encoding from the following options: /Encoding:[ ASCII...

  After many months of hard work, collaboration, short weekends and nights, the new ALM Rangers guidance document is out covering Visual Studio Database Projects. Details about the documents and the documents themselves can be found here: Visual Studio Database Guide   on Codeplex   You...

Yesterday at the PASS conference I met an former colleague and he asked me about a particular challenge applying changes to the production database from Visual Studio Team System Database Edition. As he didn’t know about the new features of the deployment utility VSDBCMD.EXE, I decided to make a blog...