22 October 2009

How To Resolve “Schema Compare does not support SQL Server 2008” Issue Of Visual Studio Team System 2008 Database Edition

by Gopinath on Oct.22, 2009 @ 11:30 AM IST, under Microsoft, SQL Server.

Hello there! If you are new here, you might want to subscribe to the RSS feed for updates on this topic.

I wanted to synchronize a SQL Server 2005 database with SQL Server 2008 database using Visual Studio Team System Database Edition. When the synchronization process is launched, Visual Studio 2008 flashed an error saying i don’t work with SQL Server 2008.

The exact message displayed by the system is

Schema Compare does not support SQL Server 2008

It was a surprise as I’m using the latest version of Visual Studio with Service Pack 1. But after googling I understood that we need to install “Microsoft Visual Studio Team System 2008 Database Edition GDR R2″ from Microsoft to resolve the issue. Here is the link to download

http://www.microsoft.com/downloads/details.aspx?FamilyID=bb3ad767-5f69-4db9-b1c9-8f55759846ed&displaylang=en