After some time with no visible new versions, today dbdesc and dtsdoc got both an upgrade. During this time I’ve been silently uploading new build versions to fix small bugs. Now it’s time to tag those fixes as new point releases and add a couple of features.
Even though dbdesc supports SQL Server 2008 since RC0, it was not able to document CREATE TABLE scripts. Finally dbdesc is able to pick the latest SMO version and produce those scripts. If you try to document a SQL 2008 database from a machine without SQL Server 2008 you’ll need to install this component from Microsoft: Microsoft SQL Server 2008 Management Objects. If this component is not available, the database will be documented just fine but table scripts will be missing.
When using Data Driven Query Tasks or a Data Pump Tasks, you can apply some transformations to the data. The usual transformations are copying columns and running an ActiveX script. However there are others like ReadFile, WriteFile, UpperCaseString, and others. These transformations happen to have its own custom properties, and previous versions of dtsdoc were not documenting them.
This version also shows the package names of a server sorted alphabetically. You could do that before simply by clicking the list header, but an anonymous user asked why there were not sorted this way in the first place. Very true.