270 results found
-
4 votes
-
Option for 'Ignore Users'
Can we have an option that allow us to ignore the database users?
Thanks
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 -
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 -
Easier Method to Snapshot Multiple Databases from same server(s)
1) SQL Compare has handy database snapshot ability to a folder. It would be great if rather than creating 1 database snapshot at a time you could tick each of the databases you'd like a snapshot created for.
2) Would be cool if like SQL Multiscript tool, you can speficity multiple servers and databases and have the snapshots named and/or placed in folders with server and database names.
4 votes -
Enhance support for default constraints
I need to replicate a database for read-only reporting purposes and the production database is littered with all sorts of default constraints.
For example:
ALTER TABLE [schema].[table] ADD CONSTRAINT [DFtablecolumn] DEFAULT ('Unknown') FOR [column].
This is what the definition is in SSMS.In SQL Compare:
[column] [varchar] (15) COLLATE SQLLatin1GeneralCP1CIAS NOT NULL CONSTRAINT [DFtable_column] DEFAULT -- No text is available,
Now the constraint fails AND the comma separator for the next line is missing.
Another fun one:
[SCD Surrogate Hash Key] AS (CONVERT([varbinary](64),hashbytes('SHA2_512',coalesce(CONVERT([varbinary](50),[column]),0x00)+0x0001))) PERSISTED NOT NULL,
And SQL Compare loses all track…
4 votes -
Bring back the neat and handy ability to popup the differences window.
I used to review the changes on a separate windows on a vertically aligned monitor. This allowed me to fast review changes of most objects without using the scrollbar.
Now, for even a small table with constraints, FKs and permissions there is scrolling needed. I need constantly to resize either that upper panel to see objects or bottom one to see changes. SQL review tasks are taking much longer now.
The Summary view is a nice concept but far from production usability.
5 votes -
Option to deploy dependencies without referencing objects
Currently, the deployment wizard allows us to select referenced objects and referencing objects. It would be nice if these could be separated so there were two different options. My scenario is wanting to create a small testable DB and only bringing over the minimal amount of schema to get things working. Dependencies are clearly needed, but I don't need objects that rely on the objects deployed.
4 votes -
Allow me to exclude users in DB compares.
I use something like domain\UserDEV for development and domain\UserPRD for production.
I can ignore a users permissions but I don't need a list of users that I know won't exist in different environments.
This confuses business users when I try to show/demonstrate the exported report.
4 votes -
Support the new SQL Server 2025 VECTOR data type
We need SQL Compare to compare and synchronize changes to this new data type across environments.
4 votes -
Table Name Filter with WildCards for DBs with Huge numbers of tables
When dealing with databases that have large numbers of tables, SQL Compare takes forever and often times out when gathering initial schema information. It would be nice to have table filters to specify table names with wildcards, so we don't have to wait for EVERYTHING to load (if it does). I've been using this product 10 years and this is the enhancement I've always dreamed of.
4 votes -
Add Summary Details to Script
It would be helpful if the comment header of scripts generated by SQL Compare included the list of Actions present in the Summary tab of the Deployment dialog box.
We keep copies of all Production deployment scripts, but without scanning through the entire script, it can be hard to identify what is going on in each script. Having an option to include that data in the comment header would make it easier for us to track down and review what changes went out with what release.
3 votes -
Add Ignore whitespace in string literals option
The behavior of the "Ignore whitespace" option was changed in version 13.3:
SC-9967: "Ignore whitespace" option is no longer applied to string literalsThis option would retain legacy functionality by adding the ability to still ignore whitespace in string literals.
3 votes -
Attempts to add columns to table after dropping it in generated script
I just updated to SQL Compare version 13.4.0.6563 and tried to generate an update script for a database.
Several tables should have had two columns added to them but there seems to be a bug as the generated script followed these steps for each:
1 Drop primary key
2 Drop table
3 Add columns to table3 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 -
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 -
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 -
Add RefreshView as an option
Can you add an option that will add the "RefreshView" statement after Alter statements for views?
Thank you.
3 votes
- Don't see your idea?