|
|
|
|
With the advent of Agile Software Development, Test Driven Development (TDD) and
NUnit, writing test code has been all the rage. Software developers seldom create
unit tests which test their logic against a database, because of the hassle of creating
a test database. Here are some of the time consuming hassles which generally need
to repeat with each database version:
1) Creating an empty database,
2) Determining the order in which each table is to be loaded,
3) Loading data into the empty tables,
4) Backing up the new test database
|
|
|
|
SqlTac will create an empty test database at the click of the mouse. Seldom is just
an empty database sufficient. The next step is to determine the order in which tables
must be loaded. SqlTac will determine the loading order for all tables in your database
with a click of a mouse. Wouldn’t it be nice if you could use data from your production
database to load into your new test database? You know all the data which seldom
changes and/or is shipped with your database. But wait, there’s more, with a few
mouse clicks SqlTac will grab that reference data and build one or more script files
that can be used to load it into the new empty database.
SqlTac does not stop there, grabbing not just your reference data, but data from
any and all tables in your database. You can even optionally provide a where clause
for each table you desire, preview the rows and grab just the rows you’re interested
in. These script files are standard text files which are basically collections of
Sql Insert statements, which you can edit and check into source control. They can
be used over and over again to load data. SqlTac will use any of these script files
to load data. SqlTac does all of this quickly and easily.
Additionally, SqlTac will backup, restore and clone any existing database. Testers
in the QA dept want and need documentation about the database. They need it in a
format which is indexed and easy to navigate. They desire this documentation to
be in the form of a help file. If you have documented your database with SqlTac
as described above, SqlTac can be used to generate a file containing all of this
documentation with a few simple mouse clicks.
|
|
|
|
1) Create empty database.
|
 |
|
2) Create load script from data in an existing database.
|
|
 |
|
|
|
|
3) Load data via load script.
|
 |
|
|
4) Back up a database.
|
 |
|
|
|