244 results found
-
Compare tab contents!
I have yet to find a tool to compare the contents of two tabs in SSMS.
Ideal would be the ability to run an executable on the temfiles of two tabs. So the user could use diffmerge or whatever they liked, But any diff-function would be greatly appreciated.I don't know if SQL Compare is the right place, but it could be.
4 votes -
Choose parts of both Source and Target side for final output to Target
My usual diff-ing tool (BeyondCompare), allows me to pick which, from a list of differences, I want to go through to a final version. I guess you might call this more of a merge-conflict-resolver than a diff-tool.
What is great about this, is that when changes have been made on both sides, I can take the 'best of both', and make sure that those go through to the final output.
Now, you might say, 'how indisciplined', to have had changes on both sides. But I've found that here, as elsewhere, absolute discipline is an aspiration, but not the answer to…
4 votes -
Display last change dates in top database strip
Display last change dates of repository for databases under SQL Source Control.
And display also last schema change date from database.
4 votes -
Add option to ignore target only objects
When comparing two databases it would be nice to have the ability to have objects that only exist in the target be ignored. It is somewhat dangerous to have an option that would cause objects to be dropped and it would be good to be able to not have that show.
4 votes -
I liked it they it was in Version 12. we could see side by side comparison. and also you used to show the last modification date
I liked it they it was in Version 12. we could see side by side comparison. and also you used to show the last modification date
4 votes -
Provide the ability to specify object permissions within custom filter rules
Currently (v 13), there is an all-or-none project option to include or exclude object permissions across all database objects. It would be fabulous to push that option down into custom filter rules so inclusions/exclusions can happen more granularly, at an object-level. Use case: the majority of our tables use generic permissions but a small subset of tables use ActiveDrictory groups that differ by environment so we have to manage them as a special case. I'd love to be able to specify something like this as a filter rule: 'generate object permissions for all tables except tables that begin with <blah>'.
4 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 -
Allow to view objects excluded by filter
Both SQL Source Control and SQL Compare tell me how many objects are excluded by the filter. I can click on the link (button in SQL Compare) to see my filter settings. What I do not seem to be able to do is view the diff for excluded objects. Can you please add a button (or similar) to the UI of SQL Source Control and SQL Compare, that will allow me to toggle the diff table content between included and excluded objects.
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 -
Change scripts should have existence checks on every object they add - tables, constraints, etc.
I've encountered this, especially with default constraints. I generate a change script. I run it on a system. Something happens that causes the script to fail. I fix the problem, but then it fails the second time because the default constraints it is trying to create are already there!
4 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 -
Make the script for execution writable
Make the script for execution writable. It would be faster to be edited in you editor that is already connected to the target database and saves time . The alternatives (save or copy) are more time consuming
4 votes -
4 votes
-
Option for 'Ignore Users'
Can we have an option that allow us to ignore the database users?
Thanks
4 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 -
Allow SQLCompare to compare and synchronize Broker Priority objects
Most of the first-class objects for Service Broker are comparable by SQLCompare (i.e. queues, services, message types, contracts, service bindings, etc). One omission is Broker Priorities. It would be nice to have those at least comparable by the tool with an obvious next step having the ability to synchronize from source to destination
4 votes -
Allow the scripting of individual sql objects
optionally have the ability script out all individual objects, rather having one monolithic deployment script, from the source that are unmatched or have diffs on the target. In my case I have a git repo that needs to brought up to date from a production server (a bit of a reverse of the usual workflow)
4 votes -
Status Messages Covering Server Names
Currently the status messages in the UI for things like Updates to the application show up as blue ribbons that COVER THE SERVER NAMES. That's annoying. The choice are to be reminded again later or skip the message or whatever. But the location for the status message should not cover the server names. Could you kindly move it someplace else? Thanks.
4 votes -
It would be helpful to provide the capability to examine two objects within the same database.
I've worked over many years with multiple teams and I observe the same phenomenon. The proliferation of OLD, _BAK, _20191123, _ETC objects as developers try out new things for all sorts database artifacts; Tables, Views, Sprocs, etc. I would find it immensely helpful to compare two such artifacts, TABLE and TABLEOLD (for example) to see what has been changed.
4 votes -
Script subfolder exclusion
When using script as a comparison source allow the ability to exclude one or more of the subfolders.
4 votes
- Don't see your idea?