Headless build can make you scratch your head (Part 1)

  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. While for some compilations specific applications…

0

The help for “The database schema provider could not be determined…”

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…

2

Update to SQLCmdScriptExpander => 0.2.0.0 is out

(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 |                     BigEndianUnicode |                     Default |                    …

6

ALM Visual Studio Database Projects Guidance is out in the wild !

  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 will find a General guidance Specific scenarios HOLs for each topic Solution…

3

Perception vs. reality, how to keep your database schema changes of different environments aligned with VSTSDB and VSDBCMD.EXE Part 1

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 post series and explain the…

0