|
|
|
|
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?
|
|
|
2) Options for building a DataAccess Layer which is based on LINQ for Sql
|
|
|
|
|
|
3) Outputs of the generated DataAcces Layer by SqlTac
|
|
 |
4) Developers want IntelliSense
|
|
SqlTac will build a data acess layer with Xml style comments which will provide
IntelliSense
|
|
|
|
5) Seaches across all Sql statements
|
 |
|
6) Find all usages of a Column.
|
 |
|
|
|
|
|
7) What are possible values for a column? |
 |
|
8) Find all triggers, views, stored procs, computed columns, etc... depend on a
Column.
|
 |
|
|
|