115 results found
-
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 -
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 exclude column from comparison, but keep it in the output for review.
Add ability to exclude column from comparison, but keep it in the output for review. It is useful for excluding columns like timestamps, app names, user names who modified records, since they add noise, but seeing them is useful to understand the source of the differences.
3 votes -
JSON
The tool needs support for the JSON data type. SQL Data Compare errors out with "Field Permissions doesn't know type [sys].[json]"
3 votes -
JSON
The tool needs support for the JSON data type. SQL Data Compare errors out with "Field Permissions doesn't know type [sys].[json]"
3 votes -
find wildcard
plz, add filtering object names by wildcards(* ?) in find box.
thanks...2 votes -
Separate ALTER Table operations
Instead of putting all alter table operations into a single command, provide an option to have them split into multiple individual operations.
Instead of this:
ALTER TABLE JobTime ADD
UUIDPayWeek nvarchar (50) NULL,
XMLEquipment xml NULL,
XMLConsumables xml NULL;
GODo this:
ALTER TABLE JobTime
ADD UUIDPayWeek nvarchar (50) NULL
GOALTER TABLE JobTime
ADD XMLEquipment xml NULL
GOALTER TABLE JobTime
ADD XMLConsumables xml NULL
GO2 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 -
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 -
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 -
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 -
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 -
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 -
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 -
Where clause gone when multiple tables selected
Earlier versions would maintain the Where Clause when it was the same for multiple selected tables. We have a project that never changes other than one part of the where clause but I have to re-enter the same where clause every time. It's only saved per individual row.
1 vote -
Ability to send bugreport from unlicensed trial
I've got some bugs during trial and I would like to send bug reports to support, but only licensed users can do it...
1 vote -
deployment script for single change
Provide an right -click option to generate the deployment change for a row (or possibly multiple rows) from the difference panel. Similar to the Show Object Deployment Script option in the summary panel.
1 vote -
Setting Comparison Key and check box selection feature
using the SQL Data Compare version 10 and Version 14.1 ( by the way I saw the same issue in version 13.)
For tables where the user has to set the Comparison Keys
In version 10 when the Comparison Key is SET and it changes to Custom , the check both between the two databases been compared is selected automatically. This is not the case in version 14.11 vote -
Allow ordering for Delete, Update, Insert statements to be in different order
Often times updating a column on a table is dependent on a new record being inserted. I would prefer to be able to define the order for these to run in.
1 vote -
SQL Data Compare does not play well with source control repositories such as SVN because of strange sorting behavior
SQL Data Compare resorts the files during every check in preventing source control from correctly reporting changes.
1) It prevents us from performing code reviews on data checked in.
2) It prevents us from figuring out who made a change and when without huge efforts.We have tried to live with this behavior but are finding it extremely frustrating.
When users add a new record, SQL Data Compare first sorts the existing file and then adds the new record to the top of the file. This makes it look like the user is performing multiple actions in source control causing…
1 vote
- Don't see your idea?