Version – 0.3.1.282 – database testing framework released


A new version has been released – it can be downloaded from SourceForge -0.3.1.282_DatabaseTestingFramework.zip.

There are no changes to the DatabaseTesting.dll

ExportDBDataAsXML – is now part of the framework and can be found in the following dir:
..\DBTemplate\tools\ExportDBDataAsXML\

A number of new sql scripts – that create default SQL objects that I add to all databases – have been included and can be found in the following dir:
..\DBTemplate\misc\DBTemplateDatabase\SQL\DefaultDBObjectsScripts\

The table below outlines the main ones:

SQL object type Name Overview
Table EventLog General purpose logging table for both database and if appropriate application events. Sprocs included to log data into this table.
Table BuildVersion Used to track database schema changes and can help correlate with application versions.
Trigger tr_DDL_Event Captures any DDL events and logs them in dbo.EventLog.
Function fn_CheckSum_TableConstraint, fn_CheckSum_Routine, fn_CheckSum_TableViewColumn Returns checksum values based on db schema.

These values are then stored in dbo.BuildVersion.

Can use these to very quickly check that the schema is as expected.

Sproc p_ExtendedProperty_Insert Wrapper sproc around sys.sp_updateextendedproperty.

Makes it a little easier to add extended properties whilst creating SQL scripts.

I would be interested in hearing from anyone who also has any ‘default’ SQL objects that they add to all databases.

Last modified: 2010-07-18

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: