Schema Compare does not support SQL Server 2008

Today I needed to compare the schema between two SQL Server 2008 databases and modify one database from the schema of the other.

In the past I have used the excellent tools from RedGate but I did not have them installed on my netbook however it gave me a chance to use the schema and data compare tooling in Visual Studio 2008 Team System edition that I do have installed on my netbook.

Going through the connection wizard setup Visual Studio gave me the following error message:

Schema Compare does not support SQL Server 2008

A bit of googling later and I found this patch that sorts this out:

Microsoft® Visual Studio Team System 2008 Database Edition GDR R2

After installing this I was able to get going and successfully update my database as you can see from the screenshot below:

Posted via email from solution revolution