Friday, April 12, 2013

Visual Studio SQL Compare - Cannot Update or Generate Script

Using SQL Compare in Visual Studio is kinda great.

However if you find you cannot generate the change script, or update the database directly after comparing because the Update and Generate Script buttons are greyed-out / disabled (see below), this may be the reason: the version of the .NET framework.



Right-click on the database project, select Properties and go to the SQLCLR tab and change the Target Framework version. 


Wednesday, January 16, 2013

App.Config transforms for non-Web projects

So I was doing a simple winform app for a client today and added an app.config to store the connection strings.
"Hmmm, lemme use this *new* (for me at least) config transform magic", I thought to myself.

Sadly, it only supports web projects (web.config). D'oh!
But no fear, someone out there has bumped up against the same issue. Thanks :)