Visual Studio for Database Professionals and other Cool Data Management Tools for .NET

Earlier today CTP6 of the Visual Studio Team Edition for Database Professionals was made available for free download. 

VS for Database Professionals has been getting rave reviews, and includes support for database refactorings, schema and data comparisons, database unit testing, and automated data generation.  You can learn more about it on its MSDN dev-center and Community page.  You can also watch a nice Channel9 video with the team here.

Two other data management tools that I've seen posted on http://weblogs.asp.net recently that look very cool and are worth spending time to check out include:

MassDataHandler - A free CodePlex project that provides a utility library to help automate data generation for unit testing (it can be used within any unit test framework). 

Data Dictionary Creator -- A free tool that helps you document SQL Server databases, and helps you keep your documentation in sync with schema changes.

Hope this helps,

Scott
Published Wednesday, October 18, 2006 7:40 AM by ScottGu
Filed under: , , ,

Comments

# re: Visual Studio for Database Professionals and other Cool Data Management Tools for .NET

Wednesday, October 18, 2006 10:54 AM by Robert Porter
Did you mean to say CTP-5? The link in your post takes you to a page that when you click the download link takes you to CTP-5 Beta download? Cheers, Bob Porter

# Visual Studio for DB Professionals and other Cool Data Tools for .NET

Wednesday, October 18, 2006 11:05 AM by DotNetKicks.com

You've been kicked (a good thing) - Trackback from DotNetKicks.com

# re: Visual Studio for Database Professionals and other Cool Data Management Tools for .NET

Wednesday, October 18, 2006 11:52 AM by Ryan Ternier
Awesome! Can't wait to get my hands on this. Thanks Scott!

# re: Visual Studio for Database Professionals and other Cool Data Management Tools for .NET

Wednesday, October 18, 2006 11:57 AM by ScottGu

Hi Robert,

CTP 6 is actually the new version that just came out.  I just updated the links above to point directly to it.  You can learn more about it here from this blog post as well: http://blogs.msdn.com/camerons/archive/2006/10/18/ctp6-is-live.aspx

Hope this helps,

Scott

# re: Visual Studio for Database Professionals and other Cool Data Management Tools for .NET

Wednesday, October 18, 2006 12:38 PM by Kevin
I have done a lot of digging yet on my question below, but I have not seen any comments about how this new DB edition fits into the Team Suite package. Will this edition be included in the full suite as a plug-in or an upgrade to the Team Suite - or is this being marketed as a totally seperate tool?

# re: Visual Studio for Database Professionals and other Cool Data Management Tools for .NET

Wednesday, October 18, 2006 3:44 PM by ScottGu

Hi Kevin,

The new product is included in the VS Team Suite - so if you have that already you get it for free.

It will also be available as a separate product for people who don't want to buy the whole suite.

Hope this helps,

Scott

# re: Visual Studio for Database Professionals and other Cool Data Management Tools for .NET

Wednesday, October 18, 2006 9:26 PM by yaip
This is great! But I am always confused about which version to have on my development box. I have VS 2005 and SS 2005 on the same machine. I am the sole developer/designer/tester/peon/etc. Which products do I need?

# Link Listing - October 18, 2006

Wednesday, October 18, 2006 10:45 PM by Christopher Steen
Remote Desktop On A Non-Standard Port [Via: Haacked ] Why Oh Why Couldn't WebPermission Be Part Of Medium...

# Visual Studio Team Edition for DB Pros CTP6 released...

Wednesday, October 18, 2006 11:18 PM by Rexiology::Work

[via ScottGu] Visual Studio Team Edition for Database Professionals just released CTP6, which...

# Visual Studio Team Edition for DB Pros CTP6 released...

Wednesday, October 18, 2006 11:21 PM by Rexiology...

crosspost from http://rextang.net/blogs/work/ [via ScottGu ] Visual Studio Team Edition for Database

# re: Visual Studio for Database Professionals and other Cool Data Management Tools for .NET

Wednesday, October 18, 2006 11:54 PM by John Smoth
I could not create a project using the sql server 2005 wizard. Keep on getting the error: sql server does not allow remote connections, which is not true. The only thing I can think of is I am running Vista RC1

# re: Visual Studio for Database Professionals and other Cool Data Management Tools for .NET

Thursday, October 19, 2006 12:09 AM by ScottGu

Hi John,

Did you launch VS by right-clicking on it and choosing the "Run as Administrator" option (see details here: http://weblogs.asp.net/scottgu/archive/2006/09/19/Tip_2F00_Trick_3A00_-Using-IIS7-on-Vista-with-VS-2005.aspx)?

If you don't do this then you aren't running in an "elevated" mode - which means you probably don't have creation permissions on your database.

Hope this helps,

Scott

# re: Visual Studio for Database Professionals and other Cool Data Management Tools for .NET

Thursday, October 19, 2006 12:27 AM by vikram
Do they work with SQL Server 2000

# re: Visual Studio for Database Professionals and other Cool Data Management Tools for .NET

Thursday, October 19, 2006 12:40 AM by John Smith
Hello Scott, Thanks for your suggestion. Actually I did that, and failed as well. I knew this trick when I played with CTP5. Without using it, I once got an error something like can not create database in 'master', and once I use it, I can create project successfully. But no luck in CTP6. John

# re: Visual Studio for Database Professionals and other Cool Data Management Tools for .NET

Thursday, October 19, 2006 1:38 AM by gozh2002
There is one SQLTools project in https://sourceforge.net/projects/scm-sql, which include a sqldiff tool to comppare the sql object difference in two sql database and a sqlupdate tool to migrate the sql object from dev enviroment to production with VSS tracking the changes.

# re: Visual Studio for Database Professionals and other Cool Data Management Tools for .NET

Thursday, October 19, 2006 1:43 AM by Jon Galloway

Thanks for the link to the Data Dictionary Creator, Scott. I'm on vacation for a week and was trying to figure out what project to work on when I saw you'd linked to DDC. That clinched it. I hope to have a new version ready when I get back on the 25th.

# re: Visual Studio for Database Professionals and other Cool Data Management Tools for .NET

Thursday, November 02, 2006 9:26 PM by Ronald Lintag
Hey John, You might want to check out this link for a solution to your issue with SQL Server connection when using CTP6: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=834993&SiteID=1 Thanks, RL

# Visual Studio数据库专业人员版和其他非常酷的.NET数据管理工具

Friday, November 03, 2006 4:36 AM by scottgu

今天早先时候，我们发布了Visual Studio Team版的数据库专业人员版的第六个社区技术预览版(CTP)供免费下载。