- or
No existing idea results
- ~ No ideas found ~
115 results found
-
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 -
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 -
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 -
My notebook was stolen and I can't deactivate my existing licence
My notebook was stolen and I can't deactivate my existing licence. Please help!
1 vote -
Speed It Up on LARGE Databases
I created a new project. DB has 2004 tables. I only care about ONE db schema - "pricemanager", so, about 20 tables, of which I care to compare just 11. It takes nearly five full minutes just to get a tables and views page I can choose from.
WHY, can I not simply "FILTER BEFORE RETRIEVAL"? I know what I want, and it isn't 2000+ tables and 5000+indexes, et al.
I JUST upgraded to 13.4.5.6953 in hopes of some speed improvement
- all hopes were dashed when it ground on for the usual 5 mins.need to eliminate the 4 typical "who" columns for each of my 11 tables bearing these columns. This is, arguably, one of the WORST experiences a Product has to offer... It is SO slow!
It is plain ridiculous to have to wait another five to ten minutes (NO EXAGGERATION) for every table I need to simply omit columns from... And while here, it is also RIDICULOUS that to edit my project to include another table, I have to wait ANOTHER FIVE MINUTES for "it" to go back to the DBs I already went to, just to collect the SAME objects, in the SAME state... GIVE US A "DO NOT RE-READ SCHEMA" OPTION! (Both while we have a project open and need to edit, OR when we first open SQDC - allow us to say, "JUST GET MY PROJECT'S CHECKED TABLES OBJECT DEFINITIONS" (getting 11 instead of 2004, now that's a speed-up waiting to happen...)
I cannot attest to this Product being a "productivity enhancer" - simply because I waste tens of minutes while unnecessary schema reads are repeatedly done, and "it" goes off into la-la land simply when I exclude 4 columns from the a table compare! Shocking it should be this bad at Version 13!
And, when I have the GRID of results on show, GIVE ME A RIGHT-CLICK TO EXCLUDE A COLUMN, there and then, while the grid is on view - and "REFRESH JUST THIS TABLE" taking into account newly excluded columns... SO. MUCH. FASTER. (Mark this "un-map" in the Project, too, PLEASE)
And this is on a MacBook Pro, with i7 processor and 16GB RAM, and SSD, so it's no slouch - and the servers are via wired 10GB Ethernet, about 150ft away, so no network latency.
ANY pointers RG can give to make this a usable tool would be greatly appreciated!
I created a new project. DB has 2004 tables. I only care about ONE db schema - "pricemanager", so, about 20 tables, of which I care to compare just 11. It takes nearly five full minutes just to get a tables and views page I can choose from.
WHY, can I not simply "FILTER BEFORE RETRIEVAL"? I know what I want, and it isn't 2000+ tables and 5000+indexes, et al.
I JUST upgraded to 13.4.5.6953 in hopes of some speed improvement
- all hopes were dashed when it ground on for the usual 5 mins.need to eliminate the 4…
11 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 -
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 whether or not the keys are the same. This is a major feature of SQL Server that has been around for several years. It is quickly becoming the standard to encrypt data. On top of this, your documentation implies that it works on encrypted data. So much so, that your own tech support thinks it does.
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
- Don't see your idea?