110 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 -
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 -
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 -
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 -
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 -
tolerance
I would like to be able to add a tolerance to use to when comparing numeric values by column if possible.
4 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 -
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 -
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 -
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
- Don't see your idea?