Activity overview
Latest activity by rgribble
Same here. We hadnt really looked at this tool, but recently had need to find everywhere in the schema that referenced a particular column. We fired up SQL Dependency Tracker but found it can only show us at a table level with no option to find dependencies on a column.
This is the sole function we turned to Dependency Tracker for, so it would definitely be a great addition.
Please add me to the list of requesters for this feature / comments
Same here. We hadnt really looked at this tool, but recently had need to find everywhere in the schema that referenced a particular column. We fired up SQL Dependency Tracker but found it can onl...
High level data comparison
I am looking for a way to compare 2 copies of a database that are supposed to be "in sync" and get a high level Yes/No status against each table, whether it is identical in each database or not.
In...
a pop up or alert window that steals focus is probably too intrusive, given that there are serveral valid situations where this will happen as you point out Michelle
But perhaps a pop up bar like the Interactive Help bar, or some other type of non focus stealing alert/notification could occur if any scripts had problems being read by the parser, and the user could click it to review the problems that occured
It would also be good to include a severity level, eg from WARNING if some parts of the file couldnt be parsed, but some valid table/procedure creation code was found and loaded, versus ERROR if the entire file was ignored as nothing could be made sense of. If possible output from the parser could be shown too, indicating the problem... in the OPs example something like "Invalid SELECT list on line xyz" would immediately pinpoint the problem. A way to view or jump to the section in the script file would be helpful too [image]
That way after running a compare, the user would see the error bar notification and be able to click it for more details if they want, then make the decision if the compare was good or not. In the above case, the ERROR and completely ignored file would be identified, corrected and then recompare the project. In a case where it was some database creation code, the user decides that doesnt bother them and continues with their work. / comments
a pop up or alert window that steals focus is probably too intrusive, given that there are serveral valid situations where this will happen as you point out Michelle
But perhaps a pop up bar like t...
FYI, your second comment about selecting specific columns can already be done
if you type
SELECT FROM SomeTable
then go back and position your cursor between the SELECT and FROM and press Ctrl-Space, the candidate list pops up. Change backwards one tab (with Ctrl-Left arrow) and you have the "column picker" tab, which shows the table's columns with checkboxes beside them, allowing you to select multiple columns at once. It then places those columns in the select list separated by commas (except the last one obviously) and also seems to obey your formatting options (in my case, each field is on a new line and tabbed/indented in).
Another similar option is when you do SELECT * FROM SomeTable, go back and position the cursor at the *, and press TAB to insert all columns from the table into the select clause
Adding similar checkbox functionality to the join conditions would be great... show each join condition with a checkbox, allowing us to select multiple join conditions to all be added (default AND logic would be suitable) in the one action / comments
FYI, your second comment about selecting specific columns can already be done
if you type
SELECT FROM SomeTable
then go back and position your cursor between the SELECT and FROM and press Ctrl-Spac...
If it helps, i too think these would be useful features
And surely it cant be that hard to just make the colum,n header a different shaded colour, if one or more records has a discrepancy in that column
A way to sort them to the top would also be nice, as the OP suggested, this would enhance productivity when wanting to look through all of the records that had a difference in the "Total Cost" field (as an example) / comments
If it helps, i too think these would be useful features
And surely it cant be that hard to just make the colum,n header a different shaded colour, if one or more records has a discrepancy in that c...
3.5 RC Unhandled Exception
I opened Query Analyzer and connected to a server.
I had set this server's "master" database in the "Connection to Ignore" under SQLPrompt Options
Once Query Analyzer was up (and still pointing at ...
Script folder only available in Pro edition
Over the last few months while many of us were Beta testing SQL Compare 6 there was never a mention of the fact that in the final verison, the script folder source is only available in the Pro edit...