108 results found
-
Filter columns to compare across all tables
I would like to have a global filter that lets you eliminate certain named columns across all tables. I have 5 columns that are in every single table - last update date, last update time, last update user, record status and record delete flag. I want to eliminate them from the comparisons in all tables without individually selecting each table in all the databases.
162 votes -
Export Comparision Results to a SQL table
We would like the option to generate the comparison result sets from SQL Data Compare to an actual SQL table for further processing. Currently our only option is to export to a CSV file.
54 votes -
Add "ignore inconsistent line endings" project option
We have a lot of data in character-based columns that is essentially the same, but because of inconsistent line endings (CR vs CR+LF) cannot be easily confirmed as "identical". For each cell we have to open the viewer and visually inspect whether we only have line ending differences or there are other (meaningful) differences.
31 votes -
If a table does not have the primary key, give us an option to use all columns on one click
When some tables cannot be compared because they do not have the primary key, give us an option to "use the combination of all columns" for all those tables, with a single click.
Even when there are duplicates, give us an option to "ignore duplicates if all others are identical".
9 votes -
Disable unique constraint indexes
If a table has a unique constraint index on say the name column and the change is just sapping the names on the IDs. The script to update the names ends up failing because it causes a unique constraint violation, but if the index is disable, then the update runs, then the index is rebuilt the unique constraint does not cause a failure.
12 votes -
Provide an automatic custom key option on Tables & Views tab
It's extremely time consuming to have to go to each individual table to create a custom key for comparing tables. Even with the common option of holding Shift to select a range. I have databases with hundreds of tables, and not all have a PKey. It would be nice to have an option that automatically selects all columns on the Tables & Views tab. You could even offer other options to select certain columns, or other ad-hoc options, for what columns to use in the compare process.
4 votes -
table Id
I am trying to compare only 1 field in the 2 tables, BUT the Id of the table is included anyway in the compare. That makes the compare result wrong. I expect identical in the result, but because the Id is included then the result is wrong. How can I remove the Id from compare?
1 vote -
Ability to send bugreport from unlicensed trial
I've got some bugs during trial and I would like to send bug reports to support, but only licensed users can do it...
0 votes
- Don't see your idea?