244 results found
-
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.
28 votes -
Allow Comparison of CDC Objects
CDC (Change Data Capture) objects are currently excluded from comparison.
Because SQL Source Control uses SQL Compare behind the scenes, this means that CDC objects cannot be committed to source control, which in turn means that databases containing objects (e.g. views) which reference CDC objects cannot be deployed with SQL CI.
I don't believe that SQL Compare should compare CDC objects by default, but there should be an option to allow it.
28 votes -
Filter Extended Properties on other objects than databases
It would be great to be able to filter extended properties on other objects than databases. We only want to compare certain extended properties on tables, but the Extended Property Filter only works on database properties.
This is similar to this idea: https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/5680027-ignore-extended-properties-created-by-the-view-des (which would be solved by filtering out "MS_DiagramPane1" on the view)
And suggestion #2 in this forum thread: https://forums.red-gate.com/viewtopic.php?f=177&t=77849&p=136399
28 votes -
Allow changing of the tab size
In the "SQL Differences" pane, tabs are expanded to 8 characters.
(Can get very messy depending how other employees have formatted the contents of stored-procs)
Could there be a way to allow this to be customized [e.g. to 3 chars] ?
27 votes -
Show/deploy static data changes in SQL Compare UI
Please add an option in the UI of SQL Compare to include static data. This would be equivalent to the command-line option "Include:StaticData"
If selected it would compare and deploy data changes to the target DB (along with the schema changes), and ideally it could also link the static data table in the target DB if not already linked. Use case is where a new table is created and linked in a dev branch and you want to deploy to trunk.
27 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 -
HTML Comparison Results
Bring back the side by side html output, please!!!
27 votes -
Add an 'Ignore owner/schema' option to SQL Compare
I'd really like this ignore option, so that [UserA].[Table] on the left hand side would match with [dbo].[Table] on the right hand side. There obviously needs to be a warning that this won't work unless table names are unique between owners/schemas (which, in my experience, they usually are).
26 votes -
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 -
ER Diagram Tool
It would be really cool if RedGate would consider building an ERD Tool that would allow you to visually design your database schema using drag and drop before deploying to SQL Server (either generating the deployment script or deploying directly from the application)
25 votes -
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 -
Make the Print Command on Deployment Scripts Optional
Hello,
We use your compare utility to deploy update's to our software. We have many many changes to our Tables/Views/Procs/etc.In each of our deployment scripts there is un-needed Print '......' & Go commands that we don't need.
It would be nice to have the option of not having these print commands
21 votes -
Option to Ignore Temporal/History Table
It would be handy to have an option to ignore Temporal/History table configuration when comparing two like databases where one has had some tables configured as temporal with a history table. This would be helpful to isolate any other changes outside of the temporal/history configuration.
20 votes -
Ability to selectively ignore column defaults
I'd like to be able to compare two databases, yet ignore certain column defaults in my comparison
20 votes -
Ability to add additional connection parameters
In SQL Server management studio you have the ability to add additional connection parameters however there is no ability to be able to specify these in SQL Compare. This is a problem in SQL 2012 when trying to connect to availability group listeners that have replicas in multiple subnets. In order to connect to the availability group listener you need to specify the “MultiSubnetFailover=True” connection property, otherwise it results in a 50/50 chance of connecting successfully.
19 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 -
No carriage returns when copying TRIGGERS text from SQL View
When copying text from the SQL View panel, in the resulting clipboard text all carriage returns are missing. A trigger of a few lines of text becomes just one single long line.
This only happens for texts in the TRIGGERS part, not in the texts of create table, constraints, permissions or functions. There are no visible differences between these texts when looking at the SQL View panel, all texts look normal so this seems like a bug.
It's quite annoying when you quickly want to fix a small difference, or just want to copy text; you have to step through…
18 votes -
Allow resizing the window from a remote desktop
When remote using Windows Remote Desktop, the main application window is not resizable. The resize cursor does not show when hovering over the edges or corners, and I cannot click and drag to change the size.
17 votes -
Compare (and migrate) Database Diagrams
I'd love to see a function in SQL Compare to compare and migrate Database Diagrams. Especially between servers, but certainly on the same server.
We use them all the time to work on the structure of the of our databases and I'd love to be able to see the same diagram when I'm working in Prod and Test as I do in Dev without having to bring the changes across manually.
The code (for the easy case) is pretty simple.
UPDATE MyDB.dbo.sysdiagrams
SET definition = (
SELECT definition
from MyOtherDB.dbo.sysdiagrams
WHERE name = MyDB')
WHERE name = 'MyDB'17 votes -
Add Last Modified Date Column to Comparison Report
Add the Last Modified Date Column to the Comparison Report, like it's shown in the Application.
16 votes
- Don't see your idea?