InfoQ

InfoQ

News

My Bookmarks

Login or Register to enable bookmarks for unlimited time.

The content has been bookmarked!

There was an error bookmarking this content! Please retry.

Refactoring and Static Analysis Added to "Data Dude"

Posted by Jonathan Allen on Sep 11, 2007

Sections
Development
Topics
.NET ,
Artifacts & Tools
Tags
VSTS For DB Professionals ,
DataDude

Microsoft has released the first set of power tools for VSDBPro, a.k.a Data Dude. These include refactoring, static analysis, MSBuild tasks for data and schema comparison, and a dependency walker.

Data Dude, formally known as Visual Studio Team Edition for Database Professionals, is an IDE for database developers who need more control over how and when schema changes are applied. The basic premise is that database developers should be able to work like software developers with changes being tested locally and applied via change-sets rather than ad-hock scripts.

The Power Tools for Data Dude has a number of enhancements that are sorely missing from the baseline product. The first in the list is a dependency viewer. It is not very interesting, but it is essential when trying to determine the impact of a change.

The refactoring support, while still limited, is definitely growing. The original release only contained a Rename operation. With the Power Tools installed, you also get:

  • Move Schema; this allows you to move an object between existing schemas
  • Wildcard Expansion; this will take any SELECT * and convert it in to a properly defined column list, if the table or view is referenced through an alias we will use the alias the properly expand the column list otherwise we propend the fully qualified table or view name
  • Fully Qualify Name; this will fully qualify each object reference, this disambiguates the your query statements completely

If a solution contains both a traditional C# or VB project and a database project, the refactorings can be applied across project boundaries. With this release it can only keep strongly-typed datasets in sync.

A new data generator has also been added. Data generators are used to populate tables with random test data, which is especially helpful when very large datasets are needed.

We added a new generator named the "Sequential Data Bound Generator", the big difference with the Data Bound Generator is that, this one only has a single row in memory at a given time and rows are dispatched in the order they are retrieved from the query results. The Data Bound Generator uses the query to fill a dictionary, holds this in memory for the duration of the generation and randomly select values from the dictionary.

MSBuild tasks have been added for comparing schema and data.

Finally, there is a static code analysis tool for T-SQL. Of the 82 rules identified, only 15 are included in this release. Still, DBAs and database developers are sure to find it just as invaluable as software developers find tools like FxCop.

No comments

Watch Thread Reply

Educational Content

Jesper Boeg on Priming Kanban

In this interview, Jesper Boeg, author of the new InfoQ book – Priming Kanban, discusses the keys to using Kanban effectively, and how to get started if you are currently using other approaches.

New-age Transactional Systems - Not Your Grandpa's OLTP

John Hugg discusses high volume transaction processing applications with high and low frequency profiles, and how VoltDB can be used for that purpose.

Cool Code

Kevlin Henney examines code samples to see what can be learned from them starting from the premise that one won’t write great code unless he knows how to read it.

Collaboration: At the Extremities of Extreme

Jason Ayers share the observations he made watching a team of developers collaborating in real time on the same code base, pushing XP, pair programming and continuous integration to their extremes.

Yesod Web Framework

Michael Snoyman presents Yesod, a web framework written in Haskell and containing a web server, templating, ORM, libraries (templating, gravatar, etc.).

Transactions without Transactions

Richard Kreuter and Kyle Banker on how to avoid classical RDBMS transactional systems by using compensation mechanisms, transactional messaging or transactional procedures.

Attila Szegedi on JVM and GC Performance Tuning at Twitter

Attila Szegedi talks about performance tuning Java and Scala programs at Twitter: how to approach GC problems, the importance of asynchronous I/O, when to use MySQL/Cassandra/Redis, and much more.

10 tips on how to prevent business value risk

One category of risk that project teams need to ensure they address is business value failure – delivering a product that fails to provide value for the business investor.