Comments
Sort by recent activity
I would like, to be able to sort the contents of the SQL Difference pane for indexes and constraints so that the name is ignored and the sort is based upon the statement itself, including table and columns. Then a match up is done between the two panes. If names are the same (everything else is same too) then there is a match and no highlight on either side. If the names are different then the names are highlighted. If the statement is missing in one table, then there is a gap across the statement in the other table. This is selectable option A. Selectable option B would be to try to match on the constraint/key names. If the names on both side exists, the statements would be matched up, even if the columns are different with the differences highlighted. The third selectable options is to compare names that are substrings of the other. For Example. ConstraintA in one table and XConstraintA in a second table. Since ConstraintA is a substring of XConstraintA, both statements would be matched and differences, if any, highlighted. I just compared 200+ tables in different databases and had to manually reconcile each of these three scenarios to determine the real differences between tables on a test system and tables that are the release standard. / comments
I would like, to be able to sort the contents of the SQL Difference pane for indexes and constraints so that the name is ignored and the sort is based upon the statement itself, including table and...
I am also looking to document what is currently the script for the view, table, stored procedure, etc. for each database being compared. I want to document what is currenly in place before I use SQL Compare generated migrate scripts to modify the DB, in case I have to undo the migration. This is particularly true for Stored Procedures and triggers. / comments
I am also looking to document what is currently the script for the view, table, stored procedure, etc. for each database being compared. I want to document what is currenly in place before I use SQ...