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