250 results found
-
Compare on object
Need an option/ability to re-compare just one object like table, procedure,view or function etc. If my database contains 1000+ objects, if I modify one of them, there should be right click re-compare menu to just re-compare that one object. Instead of comparing the whole database. Comparing whole database take a bit of time when work remotely. Even though I have filters, it takes quite a bit of time.
29 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 -
Option to "Ignore index named like nci_wi_%
Please add an option to "Ignore index named like nciwi%
These index are added by SQL Server (starting with Azure SQL DB), as part of optimizing the workload on a database.
They make it impossible to compare two databases, as too many "false" differences exists.
28 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.
28 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 -
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 -
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 -
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 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 -
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.
19 votes -
Tab size should be configurable
The comparison window seems to use a hard-coded value of 8 spaces for tab characters. The SSMS default value is currently 4 spaces per tab. So things that align just fine in SSMS are always wacky when displayed in SQL Compare. Couldn't you make this a user-configurable option?
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 -
Make SQL Compare Three-part identifiers aware and filterable
Not always a deployed database has the same name of the source database due to customers' naming conventions. So it'd be great if SQL Compare will be three-part identifiers aware, so that if you compare the same table from different named databases as following:
SELECT *
FROM MyDatabaseA.MyTableSELECT *
FROM MyDatabaseB.MyTableSQL Compare will not show them as different if you want a three-part identifiers insensitive comparison.
18 votes
- Don't see your idea?