SQL Server Database Project targeting SQL 2014

I use SQL Server Database Projects to manage my project’s DB schema changes  and keep them version controlled.  I recently got a new laptop and installed SQL Server 2014 on it. When I started a new project and tried to import the new schema into Visual Studio 2013, I ran into this error:  “Could not connect to the database to retrieve the configuration”

image

I tried a couple of things, even tried doing a Schema compare from the database to my empty project and I got another error that I didn’t really understand: “Validation error in the source: <Project Name>. Unable to determine the database platform type. The database may be unavailable.”

image

Since the database was definitely available, I did some more digging.  Visual Studio told me that the was an updated available for database tooling:

image

image

So, I followed the instructions to get it updated and magically it all worked.  So if you run into that problem and can’t figure it out, do what I should’ve done from the beginning and install the required updates!

About esteban

Esteban is the Founder and Chief Technologist at Nebbia Technology, an ALM consulting and Azure-powered technology company. He is a software developer with a passion for ALM, TFS, Azure, and software development best practices. Esteban is a Microsoft Visual Studio ALM MVP and ALM Ranger, Pluralsight author, and the president of ONETUG (Orlando .NET User Group).

2 thoughts on “Installing msysGit – Git for Windows

  1. Dew Drop – December 9, 2014 (#1911) | Morning Dew

    […] Installing msysGit – Git for Windows (Esteban Garcia) […]

  2. Mikey Cooper

    Git Bash also has some nice integration with the command line display (showing you branch information next to the working directory, for example).


Leave a Reply

Your email address will not be published. Required fields are marked *

Are you human? *