Mar
25
Written by:
Javier Callico
3/25/2009
I'm currently multitasking: writing this post and also running the uninstaller for the Microsoft Visual Studio Team System 2008 Database Edition GDR.
I was very excited with all the new features, already planning in my mind how I was going to create new database projects as part of my solutions, how I was going to stop using SQL Management Studio to write stored procedures, how I was going to start deploying my SQL changes as part of my releases until I actually installed the application and tried to use the functionality I need the most from the VS Database Edition: Schema and Data comparisons.
After trying for several hours to make it work, excusing the application and blaming the “learning curve” for the lack of progress I just decided to wait until the next version of the GDR is released.
Too many things just don’t work when comparing schemas; maybe too much attention was paid to the “new” features and the “old” features that made my company choose VS Database Edition over the duo of the Standard Edition and the most expensive Red Gate Software’s SQL Compare simply don’t work.
By the way, don't forget to follow these steps otherwise the old comparison functionality won't be there when you restart VS:
1. Uninstall “Visual Studio Team System 2008 Database Edition GDR”.
2. Open a Visual Studio 2008 Command Prompt with Elevated Privileges (Start / All Programs / Microsoft Visual Studio 2008 / Visual Studio Tools / Visual Studio Command Prompt.
3. Execute the command
C:\Program Files\Microsoft Visual Studio 9.0\DBPro\DBProRepair RestoreDBPro2008
Tags: