There's already an "Export to Excel" option, can we extend this to have an option send the results to Libre Office Calc instead?

If you want a use case, I can give you a few. But my usual one is that my Excel is busy running macros and won't respond for five or ten minutes until it's finished. So sending it to Libre Office to filter would save me some time.

My suggestion is to have an option to drop a foreign key in data compare instead of doing a "NOCHECK" / "WITH CHECK CHECK CONSTRAINT" with an "ALTER TABLE". Yes the way its done covers most cases but sometime the foreign key name need to be renamed in the same time. A drop/create can solve the issue. It's just a way to provide more control.

When I am comparing a SQL Source Control Repository against a DB, we need find an option to only compare tables which are linked for static data in source control.
This seems like a glaring missing feature, since I now have to create a project that manually maps all the tables that have static data and ignore everything else, and manually update it when new static tables are included in the repository.

I keep getting the error "Error mapping index key - try using clustered index as comparison key". I can't tell what table it refers to as it's not shown in the error message or the More Popup. It would be very helpful to display the table name when showing error messages

Our company produces many products and our team develops product configurators for it. Each product has its own database schema and a project file for independent deployment in the test and production environment. When a new product is added, all project files have to be edited to unmapp the new schema, it takes a long time and is tedious.

Please do not include quotes in the field names of the header row when exporting results to CSV. If you double-click on the resulting CSV, Excel cannot parse the column names. Instead, what you get is a single cell for each row with all of the quotes and commas in it.

I would like to see all the differences from "Only in left" and "Only in right" and "In both but different" in one view/tab.

I know you can turn off "Show identical values in results" from the project options and then use "All Rows" but that requires a re-compare which can take a long time.

An HTML report similar to the one provided with the SQL Schema Compare utility would be an excellent tool for doing QA Testing and Regression Testing. The QA Analyst could send the HTML report link to programmers to fix erroneous data. (The databases being compared would be the Pre-Test versus the Post-Test data.)

It would be useful to sort a column so that differences appear first (or last). This could be done through a right click on the column headers and selecting the type of sort to perform.

When comparing dataset with a large number of different rows (in my case 150k) where one column may having only 1 row that's different its next to impossible to find that row. Using the mouse to drag the scroller skips too much to be useful and paging down takes FOREVER.

Compare does not read from SQL backups that have used the native compression, although they can read from Redgate Backup files that have been compressed. I think that it should also be able to read from SQL compressed backups, as not all users will have Redgate Backup software.
This would be beneficial to all, because it would create a way of restoring lost data without using a partial restore, to any user that has this Compare software.

Would like to be able to assign a color to server/database combinations so that I can easily see what database will be updated. For example, my PROD database would always be colored red and it would help from pushing changes to the wrong database.

Often times updating a column on a table is dependent on a new record being inserted. I would prefer to be able to define the order for these to run in.

When a database has calculated fields, SQL Data Compare seems to process them and it takes a long time. Since these fields are calculated, they will never be updated so these should be ignored. At this time, we have to un-select each calculated field to improve on performance.

using the SQL Data Compare version 10 and Version 14.1 ( by the way I saw the same issue in version 13.)
For tables where the user has to set the Comparison Keys
In version 10 when the Comparison Key is SET and it changes to Custom , the check both between the two databases been compared is selected automatically. This is not the case in version 14.1

Provide an right -click option to generate the deployment change for a row (or possibly multiple rows) from the difference panel. Similar to the Show Object Deployment Script option in the summary panel.