Comments
Sort by recent activity
Thank you Jessica, SQL dependency Tracker could be useful, but only partially when more and more queries are coming in-line by frameworks and not longer embedded in StoredProcedures [image] I will set the request thru the link you provided. Happy weekend! / comments
Thank you Jessica, SQL dependency Tracker could be useful, but only partially when more and more queries are coming in-line by frameworks and not longer embedded in StoredProcedures I will set the...
Yes, the table has other differences;
However, with a lot of tables with "fat" triggers, I'm forced to do manual comparison to be sure that they match.
What about comparing them separately from tables, object by object, as stored procedures? / comments
Yes, the table has other differences;
However, with a lot of tables with "fat" triggers, I'm forced to do manual comparison to be sure that they match.
What about comparing them separately from ta...
I've a table with 2 triggers.
They do match (checked with Textpad CompareFile), but Sqlcompare 6 shows 1 of them as mismatching;
It's showing as missing from both databases in this sequence:
1. it'is showing missing in database A
2. the other triggers is showed as matching
3. it's showing missing from database B
I've another table with 3 triggers (Del/Ins/Upd):
Instead of comparing Upd with Upd and Del with Del, on the "left side" it starts with the UPD trigger and on the "right side" with the DEL trigger creating a mismatch.
Then INS triggers are then compared and matching.
I can provide more evidence if needed.
Same issue for version 5 / comments
I've a table with 2 triggers.
They do match (checked with Textpad CompareFile), but Sqlcompare 6 shows 1 of them as mismatching;
It's showing as missing from both databases in this sequence:
1. it'...
Hi,
I think that you can do this and much more right now once the results are extracted via XML and loaded into a relational structure which can be linked to system tables to get even more info.
I would love to have the dependency at column level and RUD!
One problem I'd like to solve is dynamic SQL.... / comments
Hi,
I think that you can do this and much more right now once the results are extracted via XML and loaded into a relational structure which can be linked to system tables to get even more info.
I ...
Hi Bart,
a great help for "us" and for "you" would be to have access to a list of bugs currently found and a list of requested features.
This would help us in time saved to report something already known (in both cases).
For the wish list, a voting mechanism could help you to determine what can be the most popular request.
Your products are very well known in the DBA arena to be easy and of great use; a "wish collector" mechanism should help you in keeping all of us on the lookout for the following release.
Have a great weekend
LF / comments
Hi Bart,
a great help for "us" and for "you" would be to have access to a list of bugs currently found and a list of requested features.
This would help us in time saved to report something alread...
Hi Dan,
I think that your vision of a typical usage pattern is not wrong and it address the need of many;
However, in the case of large shops (usually as messy as large), there is the need to have an handy and complete picture of dependencies to be used for:
Auditing
Navigation & Prevention & Planning
I would envision the use of this tool as:
Daily collection against a set of DBs
Conversion to a friendly relational structure
Comparison with previous data to detect changes
Usage of latest collection to support:
Analysis and planning
Code review
Emergency lookups
ERD tools are getting closer to provide similar capabilities, but with a much higher cost.
SQL Compare is offered in two flavors; DT could be offered in the same way:
Simple (Interactive only)
Pro (Simple + command line, ...)
I'm pretty sure you'll be able to say:
"It's used by over 150,000 DBAs, developers and testers worldwide because it's easy to use, it's fast and it saves time. " for DT too!
LF / comments
Hi Dan,
I think that your vision of a typical usage pattern is not wrong and it address the need of many;
However, in the case of large shops (usually as messy as large), there is the need to have ...
I know that graphic of the entire diagram with the "moving" effect is a nice selling point (to management :shock:), but I would provide the possibility to make the full diagram completely optional (ok, make it on by default [image] ) ;
Graphically wise, I wonder how useful and productive could be to have a graphical representation limited to dependecies (both directions) of object(s) selected in the "Objects Diagram" or "Objects Dependencies" panels.
Same output (combination of Graphic and/or text) would be great as report too.
LF / comments
I know that graphic of the entire diagram with the "moving" effect is a nice selling point (to management :shock:), but I would provide the possibility to make the full diagram completely optional...
Hi all.
As probably mentioned by many others, the core of this (great) tool success will be the capability of classifying all dependencies (column included) for later analisys.
The graphic part is nice, but not for DBs with a lot of objects.
The XML output is great; an interface to most common RDBMS will be even better, especially if the entire process (select, parse, save to table) can be made automatic via command line mode !
When the next release? (beta or final)
-LF / comments
Hi all.
As probably mentioned by many others, the core of this (great) tool success will be the capability of classifying all dependencies (column included) for later analisys.
The graphic part is ...