110 results found
-
split huge sql script to multiple serialized with selected size
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.
3 votes -
Bring back pivot view!
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.
1 vote -
Add Row Count when comparing differences
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)1 vote -
Export results in format that can be imported back into Data Compare for review
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.
4 votes -
Separate ALTER Table operations
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;
GODo this:
ALTER TABLE JobTime
ADD UUIDPayWeek nvarchar (50) NULL
GOALTER TABLE JobTime
ADD XMLEquipment xml NULL
GOALTER TABLE JobTime
ADD XMLConsumables xml NULL
GO2 votes -
Option SyncOptionIncludeExistenceChecks should be applied to data updates
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;
GOI 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?
6 votes -
Provide AWS AMI for Redgate SQL Data compare
Provide AWS AMI for Redgate SQL Data compare
3 votes -
I should be able to import an SQL Compare project into an SQL Data Compare project
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.3 votes -
hide schemas in table mapping
You should be able to hide schemas from the display of un-mapped items at the bottom of the table mappings project edit dialog.
3 votes -
table mapping where clause
On the table mapping project edit page, the Where clause functionality needs to be added to the unmapped items at the bottom.
3 votes -
export to libre office calc
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.
3 votes -
Add option to drop a constraint instead of a "nocheck"
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.
1 vote -
SQL Data Compare - Automatically select linked static tables for comparison when using Source 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.4 votes -
Include table name when showing comparison errors
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
5 votes -
Provide option to prevent the automatic owner mapping
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.
1 vote -
1 vote
-
Do not include quotes in header row when exporting
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.
1 vote -
Add new tab to show "All Different" which would combine "Only in left", "In both but different" and "Only in right"
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.
3 votes -
SQL Data Compare does not play well with source control repositories such as SVN because of strange sorting behavior
SQL Data Compare resorts the files during every check in preventing source control from correctly reporting changes.
1) It prevents us from performing code reviews on data checked in.
2) It prevents us from figuring out who made a change and when without huge efforts.We have tried to live with this behavior but are finding it extremely frustrating.
When users add a new record, SQL Data Compare first sorts the existing file and then adds the new record to the top of the file. This makes it look like the user is performing multiple actions in source control causing…
1 vote -
Add support to export comparison results to MS Excel
Can we please get the ability to export the contents of the SQL Data Compare results window (containing the rows with differences) to Excel, complete with the cell formatting seen in the application? I.e. headers for fields with differences in bold, cells with differences highlighted a different colour, etc.
This functionality exists in SQL Prompt (exporting from SSMS, admittedly without the formatting) so surely should be possible from Data Compare also?
Even better would be to be able to do this for all tables/subsets selected in the list of tables above the results window (i.e. all the data included by…
11 votes
- Don't see your idea?