Schema Compare does not support SQL Server 2008
06 Jan 2010Today 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:
