Activity overview
Latest activity by kwsmith
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...
Help doc current schema as well as Migration Script.
Please add an option to allow us to right mouse click a line in the comparison page to save both sides to two different files (one for each side). Also give us the option to click a range of lines ...
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...
Compare Tables with capability to sort columns within result
I have quite a few tables with a large number of columns. Version 7.x is good with showing the results of the comparison based upon column order. I'd like an option that allows me to change the out...