116 results found
-
split huge sql script to multiple serialized with selected size
Now there is no option to split the script generated for sql data compare for very large data. It will make memory issues while running huge data script. Splitting the insert script for migrating data will be a good solution.
3 votes -
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 -
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 -
export to libre office calc
There's already an "Export to Excel" option, can we extend this to have an option send the results to Libre Office Calc instead?
If you want a use case, I can give you a few. But my usual one is that my Excel is busy running macros and won't respond for five or ten minutes until it's finished. So sending it to Libre Office to filter would save me some time.
3 votes -
table mapping where clause
On the table mapping project edit page, the Where clause functionality needs to be added to the unmapped items at the bottom.
3 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 -
hide schemas in table mapping
You should be able to hide schemas from the display of un-mapped items at the bottom of the table mappings project edit dialog.
3 votes -
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 -
Add possibility to add CHANGE_TRACKING_CONTEXT to deployment script
Provide an option (in gui and command line) to add a CHANGETRACKINGCONTEXT to the generated deployment script.
This is helpful when using sql change tracking for synchronization to manage whether the changed made under a provided CHANGETRACKINGCONTEXT need to be synchronized or not.
When enabling change tracking we have to make sure that the data in the tables are identical on both sides. Thats were we use SQL Data Compare, but the changes made for that "initial sync" shouldn't be recognized by change tracking for later synchronization.
This would be very easy if you could just…
3 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 -
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 Compare VARCHAR columns as NVARCHAR
Don't Compare VARCHAR columns as NVARCHAR
I have a Table
with 3 columns, 2 ints and a VARCHAR(10)
CompanyID INT NOT NULL
CustomerID INT NOT NULL
YearMonth VARCHAR(10) NOT NULL -- Stores '2024-12' yes I know it should be CHAR(7)I populate the table, and take a Snapshot of the database.
I then populate the table with new code
I use SQL Data Compare to validate the data and see if I get different results. I am expecting the same, but could also expect differences.
Table has apx 5 billion rows.Problem, I see The Active expensive queries generated are …
3 votes -
I should be able to import an SQL Compare project into an SQL Data Compare project
I should be able to import an SQL Compare project into an SQL Data Compare project to get db names and such, plus table and owner mappings.
It seems like it would be a frequent thing that a compare and build would be followed by a data migration too.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 -
BUG: RedGate Data Compare "Calculating time remaining" is inefficient and incorrect
RedGate Data Compare "Calculating time remaining" is inefficient and incorrect
1. It ignores filters set on the tables. So baseline counts are incorrect.
2. Since it ignores filters set on the tables, it takes much longer, especially on large partitioned tables.
3. It runs the count queries sequentially on each data source, even though they could run in parallel.3 votes -
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 -
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 -
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
- Don't see your idea?