110 results found
-
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 -
Do not include quotes in header row when exporting
Please do not include quotes in the field names of the header row when exporting results to CSV. If you double-click on the resulting CSV, Excel cannot parse the column names. Instead, what you get is a single cell for each row with all of the quotes and commas in it.
1 vote -
1 vote
-
Provide option to prevent the automatic owner mapping
Our company produces many products and our team develops product configurators for it. Each product has its own database schema and a project file for independent deployment in the test and production environment. When a new product is added, all project files have to be edited to unmapp the new schema, it takes a long time and is tedious.
1 vote -
Add option to drop a constraint instead of a "nocheck"
My suggestion is to have an option to drop a foreign key in data compare instead of doing a "NOCHECK" / "WITH CHECK CHECK CONSTRAINT" with an "ALTER TABLE". Yes the way its done covers most cases but sometime the foreign key name need to be renamed in the same time. A drop/create can solve the issue. It's just a way to provide more control.
1 vote -
Add Row Count when comparing differences
When comparing differences in the tables, add rowcounts in the tabs.
For example, the tabs would read something like:
All(234)
Only in left (134)
In both but different (0)
Only in right (100)
Identical (0)1 vote -
Bring back pivot view!
I see from a community forum discussion that pivot view on the results grid went away after version 11.3, due to discontinuing licensing of Syncfusion components (issue SCD-2061). Please add my voice to those who found it useful and would like to see it come back! It's useful when the number of columns with differences is large, and the number of different rows is small.
1 vote
- Don't see your idea?