Skip Navigation Links
Home
Overview
Features
Lifecycle
Downloads
Support
Purchase
Skip Navigation Links.
                  Development:
Click for larger image. Click for larger image. Click for larger image. Click for larger image.
1) Structurally, what
    new/change/delete in this
    version of the database? 
Click for larger image.
2) Options for building a
    DataAccess Layer which is
    based on LINQ for Sql 
Click for larger image.
3) Outputs of the generated
    DataAcces Layer by
    SqlTac 
Click for larger image.
Click for larger image. Click for larger image. Click for larger image.
4) Developers want
    IntelliSense 
Click for larger image.
SqlTac will build a data acess layer with Xml style comments which will provide IntelliSense
5) Seaches across all SQL
    statements 
Click for larger image. Click for larger image. 
6) Find all usages of a
    Column. 
Click for larger image. Click for larger image. 
7) What are possible values
     for a column? 
Click for larger image. Click for larger image. 
8) Find all triggers, views,
    stored procs, computed
    columns, etc... depend
    on a Column. 
Click for larger image. Click for larger image. 

As a software developer, the first thing, I want to know when someone gives me a new version of the database is what has changed. Many times, there is no record of what was changed, added or deleted, causing delay, frustration and aggravation. Even when records are kept, they are often incomplete. As a software developer, I am looking for documentation describing the tables, columns and relationships. I am hoping to find it at my fingertips and in the tool with which I do my development, and that is neither Word, Powerpoint, MS Project, Excel, nor even Microsoft SQL Server Management Studio. The vast majority of developers develop in Microsoft Visual Studio and are hoping for some IntelliSense.
As a DBA/software developer, I want to know where and how a column/table is used, which stored procedures update a column, which triggers and user defined functions reference and/or affect (insert/delete rows) a particular column. Wouldn’t it be nice to have something which would scan all SQL (check constraints, default values, triggers, views, stored procedures, and user defined functions) in your database for any phrase?

Software developers need a tool to build a data access layer based on Microsoft coming technology, Linq for SQL. SqlTac addresses all of these items. No worries about whether meticulous records were taken recording all of the changes made to the database. SqlTac will compare any two versions of your database and give a detailed list which can be sorted and filtered many different ways. SqlTac will build a data access layer which is compatible with Microsoft’s LINQ To SQL, but additionally include the documentation entered via SqlTac about your database and described in the previous section of this document. Every time you build a new version of the data access layer, SqlTac will roll the version number and display it prominently at the top of the file it generates. It is this data access layer which provides developer with IntellSense inside of Microsoft’s Visual Studio. SqlTac will display all usages of a column and plus all of the discrete values for the column with a count of the number of occurrences. At a click of the mouse, you can see all rows containing a particular value for that column. Additionally, SqlTac will provide a list of all SQL items (check constraints, default values, triggers, views, stored procedures, and/or user defined functions) which reference that column. SqlTac will search on any phrase you enter, and it will report all occurrences of said phrase across all SQL items. Bookmarks are automatically set showing exactly where the phrase occurs in each of the SQL items. New developers to a project often struggle to find things in a database. The database grows over the years and it becomes impossible to keep all details in a single human mind. SqlTac is there to connect the dots for new hires and the old timers who have a touch of Alzheimer’s.
         Time is money!
 How much are you wasting?
SqlTac provides the Answers
                                                                                     Copyright © 2006-2010 Caber Computing, Inc. All rights reserved.