Activity overview
Latest activity by aspillert
This would be useful - please consider letting a user manually map a differently named items in a future version.
Thank you / comments
This would be useful - please consider letting a user manually map a differently named items in a future version.
Thank you
Compare two different stored procedures?
A database has a stored procedure named "p_training" and another "p_training1". Can SQL Compare show me how they differ?
I'm glad that you know about the issue. I will wait for your next release. I find many cases where Prompt gives me errors the SQL Server does not, particularly when a query accesses two databases, or runs from one database against another. I can see how these are tricky to deal with.
Thanks,
Alan / comments
I'm glad that you know about the issue. I will wait for your next release. I find many cases where Prompt gives me errors the SQL Server does not, particularly when a query accesses two databases...
Failure to format
The query from http://www.sqlservercentral.com/scripts ... ion/69438/ runs ok but SQL Prompt 7.0.0.62 cannot format it. I am running on SQL Server 2012 (11.0.5343.0).
A filter worked, but more painfully then it might have. I saw "Filter" in the upper right corner of the screen, and it did not work. Eventually I saw "Filter:" in the upper left, and was able to set up a filter. I chose to "include if begins with v_" and the filter included my views and many unwanted others beginning with "view__". Filters must ignore the underscore character (arthropod). The SQL code in the views was difficult to read because some had been formatted by the developer using SQL Prompt, and some had been created by the query designer and never formatted. At least I now have a list.
This would have been easier if the documentation had a few images and focused initially on the mechanics of adding and setting up filters rather than the capabilities of a filter.
Another very nice feature for a future version would add SQL Prompt formatting to code displayed by SQL Compare.
Thank you for your help. / comments
A filter worked, but more painfully then it might have. I saw "Filter" in the upper right corner of the screen, and it did not work. Eventually I saw "Filter:" in the upper left, and was able to ...
Compare a few views in a large database
I support an application package that has 6700 data tables and 2600 views, and several thousand stored procedures. We have added 125 custom views for reporting, all prefaced with "v_" such as "v_D...
Selective compare on large database
It would be very nice to be able to compare only certain types of objects on a large database. I support a database with over 10,000 tables, views, stored procedures, functions, and accounts. I r...
Compare without extendedproperty
Is it possible to exclude between sp_addextendedproperty differences between views in two databases? The Extended Property filter rule doesn't seem to do anything.
Also - can a COMPARE be done wi...
Compare vs Display
Most of my tables have a date when it was last inserted or updated. When I compare a source table to a reporting table I want to compare the data, not the dates. But the dates can be very useful ...
I had the where clause editor set to use the same where clause in both tables. When I set it to pick "active" from one table I'm seeing what I expected.
Thank you / comments
I had the where clause editor set to use the same where clause in both tables. When I set it to pick "active" from one table I'm seeing what I expected.
Thank you