Activity overview
Latest activity by lfagetti
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...
A SQL parsing engine to list SQL objects used in the statements?
Hi, I'd like to know if there is any future plan to provide a more generic engine capable to perform same and more functionalities of those in SQL Prompt.Briefly, you pass one or more objects (stor...
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...
Ignoring "NOT FOR REPLICATION"
Identity columns and Foreign keys can be marked "NOT FOR REPLICATION"
example:
[AdAttendID] [int] NOT NULL IDENTITY(1, 1) NOT FOR REPLICATION
It would be great to have an option to ignore "NOT FOR ...
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'...
Dynamic SQL and CRUD
Hi,
RGDT Vs. Dynamic SQL ?
In case Dynamic SQL exists in a SP, no dependency trace can be generated unless all the possible combinations (so far at table level) are explicitly written in a never re...
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 ...
Suggestions
Few suggestions
1. Add objects to project: alternate way via XML
Instead of performing the selection via UI, to accept a XML file that contains all the needed info (Instance, U/P or trusted, DB and...
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 ...
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...