Please add this feature when saving projects. It would be useful when the project has not been deployed, but saved for a future deployment or re-review without having to re-select all the tables.

"The project does not remember which tables or rows of data were selected for deployment."

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?

I would like to be able to add a tolerance to use to when comparing numeric values by column if possible.

I sometimes need to make changes to both the From database and the To database, it would be useful to be able to change the direction of the deployment script after having completed the comparison of the data. This would be useful in the SQL Compare tool as well.

SQL Data Compare report output can be hard to read on a small laptop screen. Zoom capability with horizontal/vertical scroll capability would be helpful for viewing report output on smaller screens.

Now there is no option to split the script generated for sql data compare for very large data. It will make memory issues while running huge data script. Splitting the insert script for migrating data will be a good solution.

I see from a community forum discussion that pivot view on the results grid went away after version 11.3, due to discontinuing licensing of Syncfusion components (issue SCD-2061). Please add my voice to those who found it useful and would like to see it come back! It's useful when the number of columns with differences is large, and the number of different rows is small.

When comparing differences in the tables, add rowcounts in the tabs.

For example, the tabs would read something like:
All(234)
Only in left (134)
In both but different (0)
Only in right (100)
Identical (0)

The SQL Data Compare GUI is the best way to review differences. I'd like a way to export my results to a file that can be re-imported for others to view, without having to go back through the comparison process.

Instead of putting all alter table operations into a single command, provide an option to have them split into multiple individual operations.

Instead of this:
ALTER TABLE JobTime ADD
UUIDPayWeek nvarchar (50) NULL,
XMLEquipment xml NULL,
XMLConsumables xml NULL;
GO

Do this:
ALTER TABLE JobTime
ADD UUIDPayWeek nvarchar (50) NULL
GO

ALTER TABLE JobTime
ADD XMLEquipment xml NULL
GO

ALTER TABLE JobTime
ADD XMLConsumables xml NULL
GO

We use SCA with the following setting:

<SyncOptionIncludeExistenceChecks>True</SyncOptionIncludeExistenceChecks>

Yet when a migration script is created for a table with data tracking enabled, there is no existence check:

PRINT (N'Add 1 row to [dbo].[ReleaseNote]');

SET IDENTITY_INSERT [dbo].[ReleaseNote] ON;

INSERT INTO [dbo].[ReleaseNote] ([ReleaseNoteID], [AppVersionID], [ReleaseNoteText], [DisplaySequence], [DisplayCondition])
VALUES (14, 4, N'You can now save calculations.', 2, NULL);

SET IDENTITY_INSERT [dbo].[ReleaseNote] OFF;
GO

I just got an error for the statement above, since the record already existed. Can you please update SCA to apply existence checks to table inserts?

Provide AWS AMI for Redgate SQL Data compare

I should be able to import an SQL Compare project into an SQL Data Compare project to get db names and such, plus table and owner mappings.
It seems like it would be a frequent thing that a compare and build would be followed by a data migration too.

You should be able to hide schemas from the display of un-mapped items at the bottom of the table mappings project edit dialog.

On the table mapping project edit page, the Where clause functionality needs to be added to the unmapped items at the bottom.

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