Skip Navigation Links
Skip Navigation Links.
Click for larger image. Click for larger image. Click for larger image. Click for larger image.
1) Create empty database. Click for larger image.
2) Create load script from data in an existing database. 
Click for larger image.
Click for larger image.  Click for larger image. Click for larger image.
3) Load data via load script. Click for larger image. 
4) Back up a database. Click for larger image. 

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 tasks which generally need to repeated 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.
         Time is money!
 How much are you wasting?
SqlTac provides the Answers
                                                                                     Copyright © 2006-2010 Caber Computing, Inc. All rights reserved.