253 results found
-
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 -
Menu bar display issues when using Remote Desktop app in Windows 10
I have trouble seeing the menu bar when using Remote Desktop app in Windows 10. The menu bar is very tiny and not completely visible. Very hard to work with.
1 vote -
Don't use "Added" and "Removed" in the Comparison Results report
I just want to share the differences between two databases with the developer and will have to explain that added or removed does not mean that anything was actually added or removed yet.
7 votes -
Ability to safely edit the previous server lists
Please see this thread
https://forum.red-gate.com/discussion/comment/162865#Comment_162865
I would suggest that because the proposed solution requires knowledge and access to the Registry this should be a feature to edit the list.
7 votes -
1 vote
-
SQL Search Right Click Modify
If would be handy in SQL Search to be able to right click/Modify instead of double clicking, waiting for what could be a last treeview list in SSMS to open, then having to right click/modify.
2 votes -
Support for Module Signing Comparison
Please could you consider adding support for the comparison of signatures between databases. Currently SQL Compare doesn't check for differences between module signatures, please refer to this forum post:
https://forum.red-gate.com/discussion/87404/module-signing-support
The consequence of this is that during deployment by SQL Compare, module signatures will be ignored, therefore causing deployed modules that depend on the signatures to fail during execution.
Additionally, should signatures be removed from a database using a command such as sp_refreshsqlmodule (which implicitly removes signatures), SQL Compare will not identify that the signatures have been removed.
1 vote -
amazon
Should work on:
how to simply install SQL Compare/SQLToolbelt on AWS EC2 instance (Windows/Linux based)?
3 votes -
index
SQL compare regularly identifies a difference between the same index between the same table stored on 2 different databases as it seems to get confused with a different index then says the the same index underneath the 'different' one, should be deleted! It must not compare on the name of the index but maybe an order? Is this a bug?
1 vote -
Option to ignore stats based on name
When recreating statistics that were "Auto Created" they now become non "Auto Created".
This means when comparing the database against the original, because SQL Compare doesn't display "Auto Created" statistics, it looks like there are loads of new statistics
I found this as I am trying to change collation of everything in a database and have to recreate the statistics.
Please can there be an option to ignore statistics if they match based on name and the only difference is "Auto Created"?
1 vote -
Add a keyboard shortcut to Next/Previous diff.
It would be nice to be able to navigate to the next diff (or previous) using a keyboard shortcut (e.g.: CTRL-N, F8, etc...)
1 vote -
Ability to create a separate re-runnable script for each object being updated in SQL Compare, instead of just one big script. This is very
Ability to create a separate re-runnable script for each object being updated in SQL Compare, instead of just one big script. This is very important to our business.
1 vote -
Make script file an editable text file so we review, edit or programmatically generate the file.
Make script file an editable plain text file so we review, edit or programmatically generate the file.
Once the script file is used, there is no good way to retrieve what were included in that file, especially if the included objects have been removed.
It will help us keep track of changes across multiple scripts (SCP) over time.
Make it an option to compress it in case it is a large deployment.
3 votes -
Page Not Found error when I try to get details on updates
Getting page not found error again when I try to get full details for updates to SQL Compare. URL being hit is https://documentation.red-gate.com/display/SC14/SQL+Compare+14.3+release+notes.
I get the feeling that this needs to be added to the "new version number" checklist or something alone those lines. Had similar issue a few builds back.
1 vote -
Refresh clears the details at the bottom. Clicking on highlighted object does not bring up details.
SQL Compare ver 14.2.16.16006 Professional. When I select an object that is different, the details pane is brought up from the bottom. If I click on Refresh, a re-compare is performed and the detail pane goes away. The object that was previously highlighted, is still highlighted. When I click on that object, the detail pane does not come up. I need to click on another object to bring up the detail pane, then click on the original object.
1 vote -
Add Version # to your objects/DB
When running a deployment (especially for the automated DevOps part, but even for creating a deploy script) you should have the option to enter/update a new Extended Property value called like “RedGate Version #” with whatever the version number you get from the source control for that object. Ideally it would be nice to also update that in the database level Extended Property as well, but at least on whatever object you are making a change to with that deployment. That way you can self-document what the latest version control number was for that particular object (or the DB as…
6 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.
3 votes -
unicode
Please support Unicode. The current version can not display my descriptions of fields with Unicode.
3 votes -
Attempt to detect table renames
SQL Compare should try to detect renamed tables and use sp_rename. At the moment, the existing table is dropped and a new table is created with the new name. To avoid data loss, it is necessary to create a migration script but SQL Compare should be able to detect this in a similar way to how it detects column renames.
1 vote -
Exlcude specific items from Deploy script from Comparison Results screen
SQL Compare
Sometimes I want to exclude specific items from deployment script when doing a comparison. For example, when comparing a table, exclude a specific trigger on that table.This is a SSDT feature that is missing in SQL Compare.
I know custom filters can be used to achieve this, but this it is cumbersome for "ad hoc" choices, and I could not achieve the results wanted for the example below.
Using a trigger associated as with a table as an example:
Assume there is a schema change with a specific table that includes a trigger. Assume that the trigger…8 votes
- Don't see your idea?