108 results found
-
window resize handles missing
On Windows 7, the edges of the SQL Data Compare window don't seem to allow window resizing, and there's no visible border separating the window from the background.
6 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 -
Have an application or project option that will allow you to turn off automatically checking differences
Have a SQL DATA Compare application or project option that will allow you to turn off automatically checking differences. In Sql Compare this seems to work a little better in that only a few or no items are automatically selected when comparison results are displayed. Right now, all differences are selected in SQL Data Compare.
6 votes -
provide additional binary data view options (i.e. PDF, Word, HTML)
When i am comparing tables with binary data i am limited to Ansi or Unicode Text, Hexidecimal or Picture. We are storing PDF, Word and HTML documents and i would like to be able to view those better to see the differences. If this is not possible how about an export to open the data into the actual application (like an "open with....." option)
5 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 edit deployment script before running it
Sometimes when copying data from server to server I need to change soemthing in the deployment script (e.g. replace a guid with another guid for a FK to work). Please allow editing the script before running it through Data Compare (currently I have to copy it, edit it and run it manually)
4 votes -
Allow sorting column by differences first
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.
4 votes -
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 -
validate where clauses
I have written were clauses for about 100 tables for data sync. while I do not want to sync just yet I do want to make sure I have no typos in the where clauses. Please add some option to run a "select top 1 where ..." from each table marked for comparison so I can fast check for where clause errors (currently I have to wait for each table to completely compare and if I have typos in the where clause of table 98 it will take me long time to find this out)
4 votes -
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 -
Update all products at once rather than just SQLDC
Have the "check for updates" check for updates to all installed RedGate products? This would be helpful for those of us on frequent updates - having to close SSMS to update Sql Source Control and then again to update Sql Prompt a few minutes later generally is a bit slow...
4 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 -
option to exclude tsqlt tables and schemas
SQL Compare can exclude tSQLt-related objects. SQL Data Compare should have a similar facility, at least for parity with SQL Compare and also to reduce false positives in the result
3 votes -
provide an option to halt the compare after 'n' mismatches to allow quicker results when expecting a perfect match
when expecting a perfect match, please provide an option to halt the compare after a user-provided number of mismatches.
3 votes -
Add ability to migrate CDC tables from one database to another
When we upgrade an application, say by adding tables, we use frequently use SQL Data Compare to move the data from the old database to the new, upgraded database. It would be great to be able to migrate the CDC data for the tables in the original version of the database to the new version!
3 votes -
Ability to Deploy Changes to Individual Columns
After reviewing the result of table(s) comparison, it should be easier to choose by clicking a box by the column header for which column(s) you want to sync across to the target DB.
3 votes -
Connection Coloring
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.
3 votes -
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 -
Be more robust in the face of Transport Errors
Data Compare almost always fails because of frequent (but short) network outages. If we could specify the timeout, this problem would be solved.
3 votes -
compare one source table to 2 or more destination tables
Allow data from one source table to be mapped to 2 or more destination tables. Due to requirement changes we needed to split data from one table in to two separate tables but data compare will only map one source table to one destination table. Some data has to be duplicated on both tables and some belongs to one or other of the new tables.
3 votes
- Don't see your idea?