Skip Navigation Links
Overview
FeaturesExpand Features
LifecycleExpand Lifecycle
Downloads
SupportExpand Support
Purchase
My Account
Home
Skip Navigation Links.
                  Development:
Click for larger image. Click for larger image. 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 SqlMetal, but additionally include the documentation entered via SqlTac about your database and described in the previous section of this document (article). 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 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.
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. 
         Time is money!
 How much are you wasting?
SqlTac provides the Answers
                                                                                     Copyright © 2006-2008 Caber Computing, Inc. All rights reserved.