Posts
Sort by recent activity
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?
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).
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 ...
Is an "inclusive" where clause possible?
I'm comparing 7 columns on EMPLOYEE tables in two databases, DEV and PROD. My "where" clause includes active only. To verify the Data Compare 7 result I'm doing simple SQL queries.
I see 7 emplo...