110 results found
-
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 -
Last Action Indicator
I use SQL Compare and SQL Data Compare and am often multi-tasking while running things. When I get back to the product, I can't remember if the results being shown are after a compare finished, or after I deployed differences.
I would like to suggest an indicator, icon, or bar be included in the display to tell me the last step that was run by the tool (e.g. Compare Completed, Deployment to [left | right] completed, etc...), or maybe a summary of the last step (compare completed #### differences found, ##,### records added | updated | deleted on 5/6/2024 2:14…
3 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 support for Amazon Redshift
Provide support for Amazon Redshift
1 vote -
Make available for MySQL
Make tool available for MySQL
1 vote -
Allow to compare source and target fields
We very often need a way to find new and updated entries in 1 DB and copy them over to the other DB. For that it would be very handy to have a way in the WHERE clause to compare the source and target field, e.g. like this:
Source.Created > Target.Created
3 votes -
Make SQL Data Compare respect the "do not use transactions" setting
The use case for this may be a bit odd but I've had a very big compare to do today - refreshing takes nearly an hour.
Now I'm putting the data from 20 or so tables into another. Trying to pass the contents of all the tables in one transaction blows out the server logs, it's just too many rows.
However, turning off the "use transactions in deployment scripts" option is ignored until I refresh the data. That means waiting nearly an hour before SQL Data Compare will respect the value in the project settings.
That really doesn't make any…
3 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.
3 votes -
Delete all rows or Truncate of target table
to make a green field before compare. Mostly i use Data compare to refresh data from the live system to the dev/qa/... which is sometimes a mess. So i have to clear the target tables by hand before.
This could be done in a global switch in "Edit project" -> "Options" but during the Deploy workflow I would remind the user and let him uncheck if required.
Or at least make a clipboard copy for the scheme.tablename from the result window to make a manual truncate easier.
1 vote -
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 -
Add sort by selected in Dialog "Edit project" under "Tables & views"
Its time consuming to scroll down to find the 5 checked tables within 400 tables in total. Please create some kind of a group/sort to show the selected on top or provide another toggle checkbox to show only the selected ones or all
1 voteIt is somewhat hidden, but you should be able to click on the header in the checkboxes to sort by this column. Does this help?
-
Behavior of "Escape" / "RETURN" for cancelling or accepting in any (modal) dialog
hi there,
i would like to have a continuous behavior throughout the whole application regarding "Escape" -> Cancel and "RETURN" -> Accept.
Its basically the same like his idea:
https://redgate.uservoice.com/forums/147879-sql-data-compare/suggestions/37568173-escape-to-close-value-details
but everywhere in the whole Red-Gate ecosystem would be much appretiated.regards,
Martin1 vote -
Aliases
Having sql-servers named "sqlserver218165", sqlserver328976" it would make a big difference if we in Sql compare could give the servers aliases, so we could compare "AccountingTest" to "AccountingProduction"
3 votes -
Data Compare - option to change behaviour of arrow keys in grids
The current behaviour is to jump between rows to the next change of the currently selected field. While I understand that can be very useful, I've never actually needed that function. In fact, in comparing quite large data sets (over 100 rows) where any of the fields can change (and frequently not the same one) it's actually quite counterproductive (especially for someone like me who's not a big mouse user)
Would it be possible to have an option to enable that feature somewhere in the application options so that I can turn it off?
3 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."
3 votes -
excel report customization
Exporting the comparison results as excel file with customization:
We are using Redgate trial version of "SQL Data Compare 14" using command line for the past couple of days for the data comparison work. As of now I understand that while exporting the comparative data in excel, each table result will be available in individual excel and the report summary for the consolidated tables. I want to know whether I can change the format of the excel file which is generated (excel customization). If so, please let me know how to do that process also I have attached the format…
2 votes -
table Id
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?
1 vote -
tolerance
I would like to be able to add a tolerance to use to when comparing numeric values by column if possible.
4 votes -
Create an option to change the direction of the update in a project without having to re-build the project
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.
1 vote -
Provide screen zoom capability (CTRL+ScrollWheel). This would help support 508 compliance.
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.
1 vote
- Don't see your idea?