|
|
|
|
|
|
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.
|
 |
|
|
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.
|
|
|