|
|
|
|
From time to time, the user complains of abnormalities. The last place they check
is the database consistency, structural accuracy and sql contained therein. Why?
It is very time consuming, and there are very few tools available to perform this
process simply and easily. Again SqlTac can be used to check consistency of data,
validity of your Sql, and correctness of the version of the database deployed. This
is an invaluable tool if you have to support multiple versions of your database.
At times, you ship your product and database, and the user modifies the database,
against your advice and the 22 warnings in the manual, then calls to complain your
system does not work. SqlTac provides you with a simple tool to quickly determine
what, if any, changes were made by your user. |
|
|
|
The support staff at times needs detail documentation on the database, in searchable
help files. SqlTac will produce help files for both the Support staff and Test departments. |
|
|
1) Check the consistency of your database
|
|
|
Detect any orphans before you ship. |
|
|
1) Validates all of Sql.
|
 |
- Stored Procs
- User Defined Functions
- Triggers
- Check constraints
- Computed Columns
|
Sql will not only report any Sql items which will not compile, but will allow you
to correct the Sql right inside of SqlTac.
|
|
|
|
|
3) Verify a deployed database against a master release version.
|
 |
|
|
4) QA, Tech support want Help files
|
 |
SqlTac will build a chm help file containing your documentation.
|
|
|