116 results found
-
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 -
Variables in Where Filters
Using SQL Data Compare I sometimes save projects with dozens of tables mapped out, and where clause filters. Using a multi-tenant database, I often find I need to limit the results to those that have a specific CompanyId or something similar, and I want to be able to run the project for different values quickly. It would be very helpful if I could define a variable in the project ...
e.g. @myCompanyId uniqueidentifier = '00000000-0000-0000-0000-000000000000';
then use that in my where clauses so I only have to update it in one place when it is used in dozens of places..
…
6 votes -
Allow a tolerance for numeric columns
I would like to be able to add a tolerance to use to when comparing numeric values by column if possible.
6 votesSuggestion: Create a view with a calculated column that will provide the tolerance range that you are looking for. You can then use SQL Data Compare on the data in the view.
-
Exporting ONLY mismatch fields to csv
Currently, the Export CSV includes Matched and UnMatched field. It would be good to only see the UnMAtched Fields so quick action can be taken to fix it. It's especially painful when you have a table with a lot of fields and only a few are unmatched.
This feature is currently only available inside the tool. See https://us.v-cdn.net/6029854/uploads/editor/1m/d9ozpaupqkzc.jpg
6 votes -
Ignore varchar/nvarchar differences.
We'd love the ability to be able to ignore varchar/nvarchar differences between databases. We have separate databases that are essentially the same, except all varchars are nvarchar to support unicode.
At the moment, we cannot use SQL Compare to compare the two databases, as every Table/SPR/UDF comes up with changes.
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 -
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 to use the default value or empty string for a NOT NULL column in the target DB that contains NULLs in the source DB
If the target DB has some columns that don't allow NULLs, but they did in the source DB, the inserts fail as it tries to insert NULL.
I think there should be a configurable option to make it either use the default value of the column or an empty string in place. As part of the insert the script could be ISNULL(ColumnName, 'DefaultValue').
Many thanks.5 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 -
Ignore a column during comparison (BLOB) but include in Deploy
We have certain tables with BLOBs (varbinary(max)) which takes ages to compare between two databases. But if i exclude this column for comparison, it wont appear in the deploy, which will fail (in my case) caus its "NOT NULL" column.
In short:
make an option to ignore columns on compare, but keep in deploy.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 -
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 -
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 -
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 -
Add ability to exclude column from comparison, but keep it in the output for review.
Add ability to exclude column from comparison, but keep it in the output for review. It is useful for excluding columns like timestamps, app names, user names who modified records, since they add noise, but seeing them is useful to understand the source of the differences.
4 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 -
Data Compare - Save table/rows selected for deployment
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."
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 -
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
- Don't see your idea?