EntropyZero Blogging Server

So you have a database with real data that you want to use in your testing framework and you are looking for a way to get that data out so that it can be maintained in a script and be run as part of your unit tests. Thycotic Software has a great tool for generating a setup script for your test data. "Thycotic.DatabaseScripter is a simple ...

I will start the series with the DELTA_TableExists function that is provided in the deltaHelper script.  We have implemented certain guidelines on our team for writing deltas.  One guideline required that all delta be repeatable.  As you may have already noticed, deltaRunner enforces this policy by executing deltas in ...

How many times do you have to write a query against the information_schema.tables view before you finally remember the name of it and where that underscore goes? deltaHelpers are a collection of stored procedures and sql functions that are a direct result of database refactoring.  Prior to these functions the code was sprinkled all over ...

deltaHelpers is a collection of useful sql help functions and procedures that I've compiled.  These small helper functions can be included into databases managed by deltaRunner and used to help write cleaner deltas.  They are a result of refactoring and an attempt to remove duplication and complexity from our deltas.

deltaRunner is now available with signed assemblies.  This is the only difference in this release. deltaRunner can be used to manage the life cycle of your database from development all the way through production. It helps you manage versions with small incremental changes called deltas.

dataFresh is extremely easy to implement into your test framework.  I will demonstrate just how easy it is by blogging a very simple implemenation using a test fixture base class from which all test fixtures should derive.[SetUp] public virtual void Setup() {   InitializeDatabase(); } public static void InitializeDatabase() {   if ...

When you let deltaRunner create the database for you, you will reduce the amount of time required to get your development environment setup on new machines.   SqlDeltaRunner.CreateDatabase(DatabaseName, MasterConnectionString, false); Add this line when you are initializing your test fixture and deltaRunner will determine if the database ...

I've seen several attempts to manage database updates, most of which included having a bunch of numbered scripts which had to be executed manually and in a specific order during any kind of delivery.  What a mess!  I am interested in hearing how you currently manage your database updates (prior to using deltaRunner, of course) in ...

In an effort to provide a more complete TDD developer's toolkit, we are please to accounce the release of deltaRunner. This toolkit can be used to manage the life cycle of your database from development all the way through production. Once integrated, deltaRunner will increase productivity by automatically creating the database and keeping it ...

Manage the versioning of your database from development all the way into production through the use of small incremental changes called deltas.  Both as a standalone console application and as a .NET API, deltaRunner can be integrated in to your automated build/deployment scripts as well as your local development environment.