Tuesday, May 12, 2009

Amazing tool for VS 2008 and Sql Server

I was just told by a friend that I need to check out what he called “Data Dude”, which is an add-on for Visual Studio 2008. 

It adds a Database Schema compare so that you can compare two different databases.  I ran it on our beta db and dev db, and found several differences that I didn’t expect. 

Everything from triggers, indexes, columns, etc. 

dd1

It’ll let you drill down into the dependencies, allow you to make the updates, or create new items, etc:

dd2

You can easily see the differences:

dd3

Here’s the Link:

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

No comments: