110 results found
-
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 -
Please don't cover the header with update notices
When updates are available, you cover part of the header. Please do not cover this information. (screen shot available upon request)
7 votes -
Add the possibility to trim leading white space
An option for trailing white space does already exist. Unfortunately there is no option for leading white space yet. This would be very useful and propably is no big deal to implement.
12 votes -
Maintain table mappings when switching comparison types
If you have a project with a bunch of table and view mappings configured, you can easily switch between (similar) databases and retain those mappings. However, if you switch from the database type to the scripts type, even if the schema is basically identical, any mappings with filters get unchecked, but the rest remain selected. RedGate silently makes this change, and it should be considered a bug. Let me choose which action to take. If you try to re-enable those mappings, the filters are only applied to one side of the comparison, which is also an issue.
7 votes -
Need ability to select certain dependencies versus all
When creating deployment script, would like the option to select from the list of dependencies rather than all or nothing.
1 vote -
Include History tables together with temporal tables in comparison
I need to compare and sync history of temporal tables as well when testing our system in different environments. Competitive products already have this feature.
16 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 -
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 -
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 -
Please improve compare of XML columns
Its great that you can tell if xml columns are diffierent. But please improve the ablity to view the doc and see the differences. Being able to save change would also be great.
1 vote -
Enable comparison of columns encrypted with Always Encrypt
Currently if you try compare tables with encrypted columns, you get a cast error. It doesn't tell you that encryption is not supported. In fact it took your help desk two weeks to tell me it doesn't and suggest I post a feature request here. I do not know what mechanism you use to connect to SQL Server, but all of my other SQL Server clients support it seamlessly. That includes ODBC. Even if you didn't want to enable decrypting the data you at least could just allow the comparison on the encrypted values, and let the user worry about…
8 votes -
Add "xxx tables or views with 0 rows" to the result list
Today, empty tables that have no rows appear in the list of "xxx tables or views with identical rows only". It would be more accurate to split this list into tables/views with data that are identical and table/views that are empty.
3 votes -
find wildcard
plz, add filtering object names by wildcards(* ?) in find box.
thanks...2 votes -
Have an option to send only selected items in the .csv reporting.
It would be nice to have a quick way to send only the items I intend to process via a report. Currently in 13, I can only send everything.
1 vote -
Update info page is broken -- provides no information on what is included in the update
Fix the page -- give us some indication on what is fixed and/or what enhancements are in the update so we know if it is worth installing or if we might as well wait until next update.
1 vote -
Move "automatically add new tables" to "data sources" tab
If I'm working from an old file, sometimes I need to add to the definition in there. But there are new tables, so I need to turn off "automatically add new tables".
However, the only way to turn it off is to change to the tables & views tab... which then adds all the tables you didn't want before you have a chance to turn it off.
It save a lot of time to move this option to "data sources", so I could set it before changing to the tables tab and I now have to find all the new…
3 votes -
Project level variables / merge fields
We use data compare to run a sync of lots of data across many tables all linked to a specific organization in a multi-tenant db.
It would be great to be able to define a variable at the project level, e.g. InstanceID, then be able to set a sql comparison to InstanceID = [InstanceID] (or @InstanceID). That way we could copy a project and just edit the InstanceID instead of going into 30 definitions and changing every ID. Would be most useful as a simple text replace, so we could use "between 1 and 2" or like 'abc%'.1 vote -
compare two tables in the same database
I don't see why the tables have to reside in different databases, backup, source control, or scripts folder in order to run SQL Data Compare.
It wouldn't be much fuzz to add the ability to compare two tables regardless (i.e. in the same database). Sometimes I just need to divide the common traits from the differences, in order to plan some work.
11 votes -
Provide option to include USE statement in deployment script (just like SQL Compare)
Currently, we have to manually edit every SQL Data Compare deployment script to add a USE <DB> statement at the top. We would like to see an option in the tool like SQL Compare has.
14 votes -
Custom computed comparison key for matching table records
Originally introduced in this thread: https://forum.red-gate.com/discussion/comment/149220#Comment_149220
This is a common problem for us when using Data Compare. Parent table has unique constraint on a char field alongside an identity field which also serves as a one-to-many foreign key in the child table. The child table uses an identity field to distinguish each row but there's no guarantee the id's will be the same across databases so only the parent can be matched but the child table only has the parent_id identity fk which is not a viable comparison key.
My proposed solution would be to allow user to define a…
15 votes
- Don't see your idea?