239 results found
-
give more information in header
The report header shows only the database name. Seeing BobsDB -> BobsDB isn't useful. I would rather have something like: DevServerName.BobsDB --> ProdServerName.BobsDB
6 votes -
automap link directly to view/edit table mapping
When SQL Compare apply an automapping on column name of a table, there is a little yellow image with "Auto Map" displayed on the table. It would be nice if a menu or double click or else would be availaible to open directly the column mapping of this table. It would be faster to see the mapping applied and correct it if needed.
7 votes -
HTML Comparison Results
Bring back the side by side html output, please!!!
27 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 -
Comparing TFS Changesets
When comparing a TFS Changeset in SQL Compare it will show all schema changes that are different between the Changeset and the destination, but within a TFS Changeset, there is metadata within the Changeset to indicate which specific database objects are being changed within the Changeset. It would be a huge timesaver to allow SQL Compare to be able to only select the database objects that are actually being impacted by the Changeset by default. The situation I have is this:
Developer 1 - Adds a table to database A and checks in the change to the development database, but…
6 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 -
My projects - compare all projects
Add an additional "Compare all" button to compare all projects in the actual "Look in" folder. Show a simple is equal/different indicator on each project for the results.
Consider using VS-style solution files or kind of meta-scp.
This is somewhat similar to https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/13517250-auto-compare-after-oping-a-project-mass-compare
6 votes -
Unecessary table rebuild
The tool will try to rebuild the whole table even when the only thing needed is the addition of one column. If you need it, I can send an image of the comparison results. To work around it, I search for rebuilds within the generated script and substitute them by the needed command, specially if the table is a very large one.
1 vote -
When comparing sequences, should be able to ignore the START WITH value
When comparing sequences, ANY difference triggers the program to indicate a difference. In reality, when it comes to sequences, the START WITH value changes with use. If two environments are being compared and one is used for different testing, or even as a production environment, the START WITH value will likely be different. This doesn’t mean the sequences are different and, in fact, can lead to serious problems for objects that rely on the next value in the sequence being unique. There should be a way to ignore the START WITH value when comparing sequences.
26 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 -
ignore constraints
Option to ignore missing default constraints. Often when comparing two table defs, I want to see if columns or data types have changed but am not concerned at that moment about default constraints. Would like to see an option to ignore missing contraints.
16 votes -
Merge stored procedure differences line by line
Add the ability to merge differences between two stored procedures into a new file that can be ran on the server on a line by line basis.
I.E. 10 lines are different in a stored procedure between a file in a folder and a file on the server. I only want to promote 5 of those differences up to the SQL server, adding the ability to merge those 5 changes into a new file would be super helpful instead of having to copy the file from the server and hand merge them.
7 votes -
Make SQL Compare easier to use across many database projects by allowing saving project options and filters as template
Each of our production SQL servers has dozens of databases on it. We have a SQL Compare project file for each database to compare it between the production and dev servers.
Sometimes we find out that we've been using different comparison settings (either filters or project settings or both) between databases that results in us not finding differences that we should have, in hindsight, found.
It'd be super if there were a way to define the filters + project settings by at a higher level, and perhaps tied to either the database name, the source server, or the target server.…5 votes -
Install updates for all products at once
I'm using the Update software feature directly from the application. we have 3 products licensed, and i have to run all 3 updates separetely. i would be nice to install all 3 products with one setup run.
9 votes -
Filter Improvements
I use SQL Compare very rarely. Most of the time I use it to find the differences between two databases with different structure version. And therefore I need to see in a blink of an eye what dml triggers are missing or outdated or whatever. Currently there is no possibility to filter for table objects like dml triggers.
It would be very nice if there is an option to restrict the view depending on sub elements like Index, Column, Collation, Trigger.
Maybe it would be enough if the seach bar at the top would also search the SQL view of…7 votes -
Igonre create proc / create procedure commands
I have some stored procedures created in database A with the statement 'create proc' and in databse B with the statement 'create procedure'.
An option to allow me to ignore this case will very useful.
Thanks, Ésio9 votes -
Option to delete identical records from Target
Option to delete identical records from Target.
I had the need to find all identical rows and remove them from the target as they shouldnt be there. I had to use the export to CSV, and using the data generator create a table with the 81k id's and then perform a delete in sql managment studio on the temp table to delete them.
It would be so simple an usfull to be able to just select an option to delete identical rows from target in the Data compare or is there an option to control this
I can choose to…8 votes -
Support CREATE OR ALTER instead of CREATE
Sometimes, we create the migration script using SQL Comapare and schedule it for deployment. Then, it turns out, some feature has to to production ASAP, so I create the procedure there manually.
I would love the script not to fail in that case, ie. to ignore and overwrite the existing procedure.27 votes -
Colors and screen format need help
Main window which displays comparison results needs more color so differences standout. Little black boxes to indicate same, differences, left, right are not easy to quickly focus on. Must be a bug with the window sizing. Cannot size comparison results screen which spreads all content out and server/db for source and target at opposite sides of my 24' monitor. Can't size columns either.
13 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
- Don't see your idea?