261 results found
-
in sql compare, list of items changed should be readable from scp file
Sql compare produces an scp file which is an xml file. However, the contents of the change is compacted and encoded, and not readable in text editor.
I wish the list of objects to change can be directly readable from the xml. "Generate comparison results report" is bulky and cumbersome. It would be nice if we have some very short summary in the scp file itself.3 votes -
1 vote
-
Next/Previous Difference buttons to keep cursor in middle of text
Currently, when going through differences, the highlighted line can be at the bottom of the window, so subsequent lines cannot be seen. It would be better if the view scrolled around the cursor position so that the current difference was always in the middle of the window.
3 votes -
Let SQL Compare adopt the Comparison Options of Source Control Source
Unfortunately SQL Compare does not adopt the Comparison Options specified by the Source (here git repository created by SQL Source Control) which are saved in "ComparisonOptions.xml" in the git repository. Instead in SQL Compare I have to click on "Edit project" -> "Options" and check again "Ignore users' permissions and role memberships". This feels somehow not intuitive. During setup of the SQL Compare project a checkbox "adopt comparison options from source" would be nice - or maybe an "adopt" button just after setup.
I saved the SQL Compare project as an .scp file which in fact is an XML file.…
12 votes -
Option for 'Ignore Users'
Can we have an option that allow us to ignore the database users?
Thanks
7 votes -
Ignore datatypes
I created a new database based on an existing but replaced all datetime columns by datetime2(2) and do not want to show this as difference neither want it be rolled back, when I create deployment scripts.
Same could happen, if I change the size of a varchar, decimal or integer datatypes (bigint <> int <> smallint ...) and even, if a number is in one database is stored in a varchar field, I could want to ignore this and deploy only everything else
See also
https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/7109654-an-ignore-option-for-differences-between-varchar
which suggests to ignore varchar vs. nvarcharBTW: I solved my problem by syncing…
9 votes -
Connections page
I cannot connect to my databases on startup. The credentials are the same as I use in other programs and scripts but no dice. Some more meaningful error messages as well as options to specify the port and not clearing down the user/password fields would also be useful.
4 votes -
Option for 'Ignore Users'
Can we have an option that allow us to ignore the database users?
Thanks
4 votes -
Option to ignore rowguid column generated by Merge Replication
When SQL Server sets up merge replication it creates a rowguid column to maintain integrity between the tables of the publisher and subscriber. Typically this setup doesn't exist in non-prod environments which ends up generating false positives differences.
31 votes -
4 votes
-
Report preferences should be stored in the project
It would be helpful if the definition for SQL Compare reports were stored in the individual projects and not as an application preference. I have 5 different databases and use the report on differences for all 5. I always have to switch the path for the reports. This change would solve that issue.
1 vote -
Bring back the side by side html output!!
Many people have stated this but the side by side html output was more helpful and saved more time for us.
23 votes -
Add option for older version of HTML Report in SQL Compare 13
The new version of the HTML report is not as useful as side-by-side comparsions. I don't like the new version, and the developers like it even less. Thanks!
60 votes -
/force command no longer creates directory if it does not exist
In previous versions of SQL Compare the /force switch would create the entire file path that was specified for the report output. In version 13, if any of the path does not exist the report generation fails for a 'Could not find a part of the path' error. Only if the path and the file already exist, will the /force switch work.
4 votes -
Delete custom filter confirmation
I would like to see an option when clicking the trash can next to a custom filter rule, it would ask "Are you sure..." (I'll leave the text up to you). Too many times, I have clicked on the trash can instead of the pencil (edit) and poof--all my filters for that object type are gone.
3 votes -
HTML Comparison Results
Bring back the side by side html output, please!!!
27 votes -
Add high contrast or colorblind friendly highlighting
Previous versions of SQL Compare had much higher contrast on change highlighting in SQL View. SQL Compare 13 has a highlight tone that I can barely see at all. Please consider adding either configurable highlighting, or high contrast modes so people with vision issues can easily see changes.
4 votes -
New interface worse than version 11.3
Hi
I shortly was using the newest version of Data compare and Sql Compare. And I find it a bit too dark, to crowded. Hard to find the different options to compare, deploy.
I today migrated to a new machine and installed back again version 11.3 and that make me happier than the last version. Also my co workers using the new version are not happy about the user interface
4 votes -
Side by side compare.
Please bring back the compare results in a side by side compare with modify date as in compare version 12
19 votes -
compare multple databases
I'm going through an exercise of determining object changes between versions of an app suite containing 55 databases.
It would be nice to be able to specify which databases to compare during a single run instead of processing it one database at a time.12 votes
- Don't see your idea?