69 results found
-
Make tool available for MySQL
Make tool available for MySQL
2 votesWe now have comparison technology available for MySQL databases in Flyway Teams and Enterprise. Learn more - www.redgate.com/flyway
-
Option to set 'Encrypt' off by default in the project screen.
I have to click this off EVERY time I use SQL Compare or I can't connect to my databases. Can we please have an option to set this 'off' rather than 'on' by default?
2 votesIf you are using connection details that were first used with older versions of SQL Compare that did not have the checkboxes, then you will have to clear the previously saved credentials in order to be able to save the new desired ones with the checkbox values.
In order to do this you need to go into the windows credentials manger in the windows control panel and remove the saved credentials for the desired connection. Thank you!
-
Fix version 14.8+ so we don't have to type in ";Trust Server Certificate = true" for every server name
Fix version 14.8+ so we don't have to type in ";Trust Server Certificate = true" for every server name. We don't have to do this for other tools from Idera, Solarwinds, Orion, Microsoft, or any others. This is a bug in SQL Compare and SQL Data Compare newer than v14.7.7.21053
4 votesThis was shipped in SQL Compare v 15.0.2.22953 on Jan 17th, 2023. Thank you!
-
Add a button to copy Database name from one side to the other in New Project
Most times when comparing environments, the Database name is the same. It would save time to be able to copy over the Database name from the Source to the Target, rather than having to type or select it from the drop-down list.
4 votesThe button at the bottom will copy all the information from one side to the other, then you can just update the server and other details. Does this help?
-
MySQL 8 Compatibility
This should be a no-brainer, but nobody from Redgate is responding to the numerous topics and posts in the forum.
Everyone is getting the error "Unable to cast object of type "System.Byte[]" to type System.String"
Thank you from everyone who uses MySQL Compare
9 votesWe now have comparison technology available for MySQL databases in Flyway Teams and Enterprise. Learn more - www.redgate.com/flyway
-
Compare based on Selected Schema
I would be ideal if there was the ability to compare just a single Schema in databases. Example, exclude all dbo object and just include all objects in the XX schema. This would speed up the compare, as we would only be comparing objects in the XX schema and ignoring the 10K objects in the dbo schema.
10 votesThis is possible using filters. You may not see a performance improvement, because the filter is applied after the comparison completes.
-
multi factor
Support Azure AD auth using MFA
93 votesWe shipped Azure Active Directory Interactive Authentication as part of Compare 14.2.
-
Sort by Last Modified is broken
Sort by Last Modified is broken in SQL Compare 14.0.6.13387.
When I click the column heading to sort (Source or Target, order changes, but is definitely not ascending or descending.
And the Last Modified value shown in the grid does not match that seen in sys.objects, information_schema.routines, or object explorer details.1 vote -
With SQL Compare 13 the compare report option to look like previous versions
Add Compare Report option to have the old format of side by side comparison of changes. This was an easier view of the changes then the +/- lines
13 votesWe reinstated the old report type in version 13.3 as the ‘classic HTML report’. See our release notes here:
-
Generate Html report older version is better, new version has lot of scrolling.
older version side by side comparison report better than the new version vertical comparison.
7 votesThe old Interactive HTML report type was reinstated as the Classic HTML report type in Compare 13.3.
-
SQL Compare to create indexes using WITH (ONLINE = ON)
When creating indexes on large tables, it would be very beneficial to include the "WITH (ONLINE = ON)" in the create statement for the index to prevent table locking. This will need to be optional because not all server versions support it.
1 vote -
Ignore MASKING FUNCTION on columns
Dynamic masking functionality is new to SQL 2016. It is applied on columns.
https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking
Great for DEV and UAT environments where data obscurity is required.
CREATE TABLE Membership
(MemberID int IDENTITY PRIMARY KEY,
FirstName varchar(100) MASKED WITH (FUNCTION = 'partial(1,"XXXXXXX",0)') NULL, *ignore these
LastName varchar(100) NOT NULL,
Phone# varchar(12) MASKED WITH (FUNCTION = 'default()') NULL,
Email varchar(100) MASKED WITH (FUNCTION = 'email()') NULL);
Ideally we need this ignored in SQL Compare and SQL Source control comparisons so it is not accidentally deployed to production.
18 votesThanks for the suggestion David, this was released today in Compare 14.1.2.
Any feedback or further suggestions do let us know.
Tim
-
Run SQL Compare on Linux/Mac
I know weird to with a MS SQL Server, but many people who have been on the platform for a while now have developers with Macs, and automation systems on linux. DLM Automation is pricing some of us out of the Redgate ecosystem. With SQL server now running on Linux seems a reasonable path. I sure hope our beloved sql compare is not going away :(
160 votesOn 4th September we shipped SQL Compare 14, including a Linux command line beta.
You can find more information in our release notes, and please do get in touch with any feedback or requests for improvements!
Tim
-
Add support for External Tables
I use Azure SQL, and there is limited cross-database functionality in that environment. Due to this I have several External Tables that I use to point to a Master Database with shared setting, info, etc. for each customer database.
When I used SQL Compare to fill out the schema for a new database it copied all of the External Tables as Local Tables, and it didn't bring over the Data Source either. This could be very handy as dealing with external tables (and especially changes to them) is a pain.
119 votesWe shipped support for External Tables in SQL Compare 14.5.
Please turn on frequent updates to get this version
https://documentation.red-gate.com/sc/upgrading/turning-on-frequent-updates
For more information, see the release notes: -
SQL Compare store options for index create\rebuild
First this may be more apparent as tedious in my case, we happen to have large tables with decent sized indexes. I would appreciate if through the setup of a SQL Compare project I could impact index create or rebuild behavior through the selection of on\off toggle for the switches that are available upon creation of an index.
I use some options more than others with the most frequently added option being SORTINTEMPDB = ON. I use this because when building large indexes I want to try and avoid as much as possible any unintended file growth by…
78 votesWe shipped this as part of SQL Compare 14.1.3
-
Format compare using SQL Prompt format
Ability to format the source and destination code to ensure compare is using the same structure.
157 votesIn SQL Compare v14.7, we've added a SQL Prompt view tab on the differences pane. We hope this helps you understand actual differences and not just differences due to formatting.
You can learn more at https://documentation.red-gate.com/sc/reviewing-the-comparison-results/viewing-the-sql-differences.
-
Allow SQL Compare to ignore name differences in Default Constraints
Since default constraint names are system generated, they may have the same defintion but a different name.
22 votesThe ‘Ignore System named constraint and index names’ option should address this issue, unless I’ve misunderstood?
-
Version 12 "Edit Project" UI: backspace should *not* clear out the database name
In version 12 pressing "backspace" while typing the database name in the "Edit Project" screen clears out the database name completely instead of just deleting the last character.
Made a typo while typing in the database name? Too bad, you'll have to type the whole thing again after pressing Backspace. Constantly switch between servers with thousands of databases with similar, but slightly different names? The Database textbox is nearly impossible to use until the database list in the drop-down is fully loaded (which can take a while) because when you go to backspace, it just wipes the text without letting…
3 votesSorry about this – it was really annoying for us as well! The good news is that we’ve recently shipped a fix to SQL Compare 12.4 (currently available on Frequent Updates: https://documentation.red-gate.com/display/SC12/Turning+on+Frequent+Updates ) – let us know how that works for you :)
-
Link to "Full Release Notes" broken -- please fix
Link to Full Release Notes on the page at the URL below is broken -- please fix. Also, I get JavaScript errors on the page -- someone should look into.
1 voteHi Ned,
I’ve spoken to the web team and they’ve just deployed a fix for this. Let us know if you see any further strange behavior.
-
Bring back the Project Browser in Compare 12
The Project Browser, that could be opened at startup, was replaced in Compare 12 with a much less useful standard Open File Dialog. Please bring back the browser. See also, https://forums.red-gate.com/viewtopic.php?f=200&t=80066
18 votesWe’ve now brought back the project browser as an option in the latest release: see https://forums.red-gate.com/viewtopic.php?f=200&t=80430 for more details
- Don't see your idea?