Back in June, I shared the exciting news that SQL Compare 12 and SQL Data Compare 12 had been released to beta. It’s been a couple months and the good news is, both new versions are available as Frequent Updates. What we didn’t explain, though, is why we’re making the changes, and why we’re doing it now.
SEPTEMBER UPDATE: SQL Compare and SQL Data Compare 12 are now fully released. Download them free from our website, or read more about the updates in my new blog post: SQL Compare v12 has landed! New look, support, and foundations for the future
Improving the architecture
SQL Compare and SQL Data Compare have both had a user interface (UI) overhaul. This not only gives a consistent, modern look and feel to both tools, but we have a confession to make: we’ve been a bit selfish (although we promise it’s for the benefit of you guys, our users).
We’ve had over 200 bugs and feature requests relating to the UI codebase and, until now, we just haven’t been able to fix bugs or develop these features in a sensible way. This has all now changed. The codebase is much cleaner, we’ve fixed those bugs and, in the last ten days we’ve released six times. This latest release sets us up to make small, quick improvements to the user experience, on top of what’s already a stable and trustworthy core.
What comes next?
As mentioned, SQL Compare and SQL Data Compare 12 are now both available as Frequent Updates, which you can enable from the Check for Updates dialog. But we still we want to hear from you. If you notice a bug, just let our Support team know on [email protected], or via the forums (SQL Compare | SQL Data Compare). If you have a feature request for v12, please let us know on our UserVoice pages:
The development team will be powering through the requests and we’ll aim to fully release v12 as the default build next month. I’ll follow up with another blog post then and tell you more about it.
From then on, we still want to hear from you. SQL Compare already supports a bunch of SQL Server 2016 features including Dynamic Data Masking, Row Level Security, and In-Memory OLTP tables, and we’re now working on adding further support. We’re hearing users are adopting Temporal Tables, for example, so that’s next on the list. Then we’ll be keeping a very close eye on UserVoice to make sure we’re delivering the valuable features you need more quickly.
So try SQL Compare & SQL Data Compare 12 for yourself and let us know what you think.
Tools in this post
SQL Compare
Compare SQL Server schemas and deploy differences fast.
Share this post.
Also in Blog
Loading data into SQL Data Warehouse
In this step-by-step guide, we’ll be walking through the process of moving data from an on-premises SQL Server to Azure SQL Data Warehouse using the Copy Data feature in Azure Data Factory. The use ..
Also in Database development
Database unit testing: Setting your team up for valued software delivery
There is constant pressure in software delivery to release at speed and often. To take an idea or fix and deliver it into the hands of customers in as little time as possible. However, releasing faste..
Also about SQL Compare
How to Customize Schema Comparisons using Auto Map in SQL Compare
It's a tedious task to have to compare two versions of a SQL script, side by side, for example to find differences between the version of the script on Production, and the one on the Test system. As a..
Published 04 June 2013
Major releases are free for users with a current Support and Upgrades contract. For example, if you have a license for version 7 of a product, you can upgrade to version 8 at no cost. When you download and install a major release, the product is licensed with your existing serial number automatically.
If you don't have a current Support and Upgrades contract, installing a major release will start a free 14-day trial. You'll need to buy a new license and activate the product with your new serial number.
To check whether you have a current Support and Upgrades contract or see the cost of upgrading to the latest major version of a product:
- email [email protected]
- call:
- 1 866 733 4283 (toll free USA and Canada)
- 0800 169 7433 (UK freephone)
- +44 (0)870 160 0037 (rest of world)
To check the latest version of a product, see Current versions.
How to upgrade
You can download the latest version of a product using Check for Updates, or the Redgate website.
- If you download the latest version from our website, you need to run the installer to upgrade the product.Some Redgate products are available as part of bundle. You can select which products you want to upgrade when you run the installer.
- If you use Check for Updates, the installer runs automatically.
You can install the latest major version of our standalone desktop tools on the same machine as the previous version. For example, you can run version 9 and version 10 in parallel.
However, installing a minor release will upgrade the existing installation. Our server tools (e.g. SQL Monitor, SQL Backup) and tools which operate entirely within SQL Server Management Studio and Visual Studio will always upgrade the existing installation.
To revert to an earlier version, uninstall the later version, then download and install the version you want from the Release notes and other versions page. You can use a serial number for a later version to activate an earlier version.
Didn't find what you were looking for?
Improved HTML report generation
Comparison reports generated in SQL Compare now have a modern look and feel providing simpler and clearer reports that focus on the differences between the compared databases, making it easier for you to quickly see what’s changed and share with your team.
Download Redgate Sql Compare
SQL Graph support SQL Server 2017 Feature
In SQL Compare 13 we have added support for SQL Graph. This new feature in SQL Server 2017 adds graph database capabilities for modeling many-to-many relationships.
This is used extensively by social media platforms such as Facebook and LinkedIn, and other businesses are now looking at how they too can explore them to reveal valuable information about the relationships between customers.
SQL Compare fully supports SQL Graph, and allows you to compare and deploy databases which include both graph and relational tables.
Improved temporal tables support SQL Server 2017 Feature
In SQL Compare has supported temporal tables for a while, but in SQL Compare 13 we have improved this support in line with the new feature introduced in SQL Server 2017.
The new functionality includes temporal table history retention policies. SQL Compare now supports customisation on history tables for temporal tables, such as customised indexes.
Azure Active Directory authentication
SQL Compare now supports Azure Active Directory authentication with integrated and password authentication methods. These options are available in the 'Authentication' dropdown in the 'Database' section of the 'Edit project' window. Note that this feature requires .NET 4.6 and adalsql.dll to be installed, click here for more details.
Saved login details
Indian songs mp3 free download for mobile. With SQL Compare 13 you now have the option to securely save your login details for databases and servers so they don't need to be re-entered each time.
SQL Monitor support
If you use SQL Monitor you can now connect SQL Compare so that deployments are automatically detected and displayed within your dashboard.
Please note: This feature will require a SQL Toolbelt license.
Improved Summary view of detailed differences
In SQL Compare 12 we added a brand new way to examine the differences between two objects in your database. In SQL Compare 13 we are continuing to develop this new feature to make your differences even easier to read.
We have added an alternative way of viewing the differences between objects in a database. The new summary view provides a more concise view of the differences between two objects by getting rid of the SQL and showing only the semantic differences between objects in a much more structured way.
Improved ordering of columns in the SQL difference viewer
In addition to the new summary view, we have also made it easier to see why two tables are different when looking at the SQL difference viewer, so that it always displays the columns in an order that makes it clear exactly what the differences are.
Red/green highlighting in the SQL difference viewer
We have also made changes to the colors used to show differences between the left and right hand sides, so that differences in the source database are shown in green and differences in the target database are shown in red.
By moving to this color scheme, commonly used in other diff viewer tools, we have increased visual contrast, making it easier to see at a glance where the differences between the source and target are. The change to the color scheme also makes it clearer that the changes to the source database, in green, will be added, or applied, to the target and those changes to the target database, in red, will be removed, or overwritten. This is in keeping with how most other diff viewer tools use red and green.
To access new features in SQL Compare as soon as they're ready, turn on frequent updates – they're typically released once a week. Learn more
Our roadmap contains details of what is coming next for SQL Compare. Check it out.
Joel is always talking about how great SQL Compare from Redgate software is. SQL Compare only works with Microsoft SQL Server databases, but is there a good piece of software that works with MySQL and the other common databases that are part of the LAMP stack (PostgreSQL, Oracle, etc)?
Nic Rodgers
Nic RodgersNic Rodgers
4 Answers
Red Gate now has MySQL Compare & MySQL Data Compare
“It’s time to say goodbye, but don’t leave me alone. After the earnest introduction, the track erupts and transforms into a searing, Latin-tinged banger. Just stay for the night,” Nicki coos on the opening lines. Trading off verses, each hitmaker brings something special. Goodbye jason derulo sounds like.
Stephen HarrisonStephen Harrison
you can use Toad for MySql , it has a compare features
Maatkit also support several different RDBMS
SadeghSadegh
Winsql is a good windows application that uses odbc to connect to any db and has compare tools. Here's the address: http://www.synametrics.com/SynametricsWebApp/WinSQL.jsp
gjutrasgjutras
Sure, this is an old thread, but it's much younger than MySQL.
I'm currently evaluating 'Navicat', which does schema and data synchronisation for the following databases: MySQL, MariaDB, SQL Server, SQLite, Oracle and PostgreSQL. It seems to be a bit cheaper that the Red-gate tools.
It also has some extra stuff: SSMS-like functionality (i.e. design tables, views etc.), data modelling - i.e. reverse engineering tables/relationships into an editable diagram. Doesn't seem to have DB source control.
P.S. - I have no affiliation to this company, or software - just checking it out. Seems to fit the bill.
DaveBoltmanDaveBoltman
Not the answer you're looking for? Browse other questions tagged sqlmysql-managementredgate or ask your own question.
Published 16 May 2017
Summary view of detailed differences
The biggest change we have made in SQL Compare 12.4 is to add a brand new way to examine the differences between two objects in your database. Up until now, SQL Compare has always relied on the SQL differences viewer to convey the differences between an object in the source database and its counterpart in the target database:
As illustrated in the screenshot above, the SQL differences viewer often makes it harder than it could be to see what the differences are. Problems include:
- syntactic differences like the addition or removal of trailing commas are highlighted but are semantically irrelevant.
- columns in different orders in the source and target cause entire rows to be highlighted as different when in fact there is no change at all.
- features that are often ignored, like constraint names, are still highlighted as different despite having no effect on any subsequent deployment.
- constraints that are inlined on one side but not the other result in both being highlighted as different but in fact they are semantically identical.
To address these shortcomings, SQL Compare 12.4 adds an alternative way of viewing the differences between objects in a database. The new summary view provides a more concise view of the differences between two objects by getting rid of the SQL and showing only the semantic differences between objects in a much more structured way:
In the above screenshot, you can clearly see the addition of a column, a modification to another and a change to a primary key constraint. We hope that the new summary view will eliminate a lot of the confusion that can be caused by noisy diffs in the SQL difference viewer.
The summary view is under development and we'd love to hear what you find useful about it and where it can be improved.
Improved ordering of columns in the SQL difference viewer
In addition to the new summary view, we have also made it easier to see why two tables are different when looking at the existing SQL difference viewer. In the past, you may have had a table with columns displayed like this:
In this screenshot, the SQL difference viewer is displaying a lot of noise because the order of the columns is not the same between the left and the right hand side. In particular, highlighting the names of columns is unhelpful; they are present on both sides, just in a different order. The actual differences between the two tables are relatively straightforward, but the SQL difference viewer is making it hard to pick out the changes. In SQL Compare 12.4 we have improved the SQL difference viewer so that it always displays the columns in an order that makes it clear exactly what the differences are:
Now that the columns are displayed in the same order on the left and right hand side, it is much more obvious that the only changes here are those relating to the DEFAULT and NOT NULL constraints.
Red/green highlighting in the SQL difference viewer
In addition to improving how columns are ordered in the SQL difference viewer, we have also made changes to the colors used to show differences between the left and right hand sides. Previously, differences on both sides were shown in yellow; starting in version 12.4, differences in the source database are shown in green and differences in the target database are shown in red:
By moving to this color scheme, commonly used in other diff viewer tools, we have increased visual contrast, making it easier to see at a glance where the differences between the source and target are. The change to the color scheme also makes it clearer that the changes to the source database, in green, will be added, or applied, to the target and those changes to the target database, in red, will be removed, or overwritten. This is in keeping with how most other diff viewer tools use red and green to mark additions in green and removals in red.
We like the new color scheme and we would like to hear your feedback on whether it works for you too.
12.4.12.5042 - August 24th 2017
Fixes
- SQL Compare no longer fails to generate a deployment script when comparing 2 source control revisions that contain migration scripts.
12.4.11.5008 - August 21th 2017
FREQUENT UPDATES RELEASE
Fixes
- SC-9551: Snapshots now correctly save REVOKE permissions
12.4.10.4968 - August 8th 2017
Fixes
- SC-9506: When all the differences in a project were previously selected then newly discovered differences will automatically be added to the selection.
- SC-9532, SC-9537, SC-9538: The SQL Compare parser now accepts syntax for new SQL Graph, ALTER INDEX and STRING_AGG features in SQL Server 2017
- SC-9534: SQL Compare will create tables before schemabound functions to resolve dependencies
- SC-9519: SQL Compare will no longer fail registration if the EXECUTE ANY EXTERNAL SCRIPT permission is present on a role object. fix: SC-9524: Fulltext changes to columns in views are now correctly displayed in the deployment wizard summary view
- SC-9520: SQL Compare will now deploy DISABLED indexes to a scripts folder
12.4.9.4945 - July 31th 2017
Features
- SC-9335: SQL Compare now supports Azure Active Directory authentication with integrated and password authentication methods. These options are available in the 'Authentication' dropdown in the 'Database' section of the 'Edit project' window. Note that this feature requires .NET 4.6 and adalsql.dll to be installed; see https://docs.microsoft.com/en-us/azure/sql-database/sql-database-aad-authentication-configure#configure-your-client-computers for more details
Fixes
- SC-9518: The layout of the backup data source grid in the new project window has been fixed
- SC-9526: The SQL Compare parser now accepts parentheses around identifiers in a CREATE FULLTEXT INDEX statement
12.4.8.4926 - July 26th 2017
FREQUENT UPDATES RELEASE
Fixes
- SC-9521: Deploying a fulltext index to a view no longer causes a crash in the deployment wizard.
- SC-9267, SC-9296, SOC-8837: Fixed a bug where for some machines database registration could fail with the message 'An unexpected error was encountered while querying the database system tables..' (with the original error message 'String was not recognized as a valid DateTime')
- SC-9501: Spurious TEXTIMAGE_ON clauses are no longer appended to tables with computed columns registered from scripts folders
- SC-9516: SQL Compare now handles dependencies between fulltext indexes and other indexes correctly
- SC-9513: Manual column mappings that would have been auto-mapped are now persisted
12.4.7.4905 - July 13th 2017
Features
- All comparable objects are now supported in the summary view! For text differences, SQL Compare will show the first actual difference between the two objects, as well as other properties such as permissions and extended properties.
- Summary view: Improved difference highlighting.
Fixes
- Filters checked into source control data sources are now applied by default.
- SC-9509: The 'Generate comparison results report' menu item will now be enabled after comparing a project from the 'My projects' window using the 'Compare now' option
- SC-9514: Switching deployment direction will no longer cause the currently selected object to be deselected
- SC-9512: SQL Compare will now report info messages (eg PRINT statements) when running a deployment
12.4.6.4860 - July 4th 2017
FREQUENT UPDATES RELEASE
Features
- Summary view: Updated UI to improve horizontal scanning. Added colors to indicate additions and deletions. Improved display of newline characters.
- Functions and views are now supported in the summary view! SQL Compare will show the first actual difference between the text of two objects, as well as other properties such as permissions and extended properties.
Fixes
- SC-9504: SQL Compare will now correctly treat multiplication/division operations as having a higher precendence than bitwise operations in the parser
- SC-9471: SQL Compare can now write constraints with an AT TIME ZONE clause correctly
- SC-9507: SQL Compare will no longer script out an empty ALTER SEQUENCE statement when the only extended properties are different between the respective sequences.
12.4.5.4811 - June 28th 2017
FREQUENT UPDATES RELEASE
Features
- The text size in the summary view is now customizable
- The SQL diff viewer now uses the red/green highlighting commonly found in other diff tools.
- Stored procedures are now supported in the summary view! SQL Compare will show the first actual difference between the text of two stored procedures, as well as other properties such as permissions and extended properties.
Fixes
- SC-9486: The deployment summary now lists all planned actions on loading the summary tab.
- SC-9508: The SQL diff view is no longer inverted when switching deployment direction.
- SC-9496: Functions which depend on a UDT will no longer compare different when the function is read from a scripts folder and the UDT is missing from the scripts folder
12.4.4.4771 - June 21st 2017
FREQUENT UPDATES RELEASE
Features
Summary view
The summary view will now display all key columns that are different between two indexes, rather than just the first different column. The summary view diff highlighting has also been improved to only perform highlighting on individual characters where it makes sense for the type of property being compared.
Fixes
- SC-9421: Improved difference highlighting in the summary tab.
- Fixed an issue in SQL Compare which could cause certain parts of the SQL view to be spread over multiple newlines when matched with an empty line on the other side of the comparison
- SC-9497: Improved Summary view display of key columns on indexes
12.4.3.4752 - June 20th 2017
FREQUENT UPDATES RELEASE
Features
SQL view
When the 'Force column order' option is not set, columns in the target SQL view will now be reordered to match those in the source SQL in order to provide a more easily readable diff.
Summary view
We've made display of column datatypes more concise in the summary view, and the layout of columns will now take column mappings into account.
Fixes
- SC-9494: SQL Compare will no longer truncate extra long warnings in the deployment wizard
- SC-9184: SQL Compare now shows if an index is disabled on the SQL view, therefore showing differences that may have previously been visually hidden.
- SC-9419: Summary view results for table columns will now take column mappings into account.
- SC-9483: SQL Compare now remembers TEXTIMAGE_ON settings on a table in a non-default filegroup and doesn't default TEXTIMAGE_ON setting when deploying.
- SQL Compare will no longer fail the comparison when using the SQL Source Control data source if there is an issue loading the source controlled filter file.
- SC-9493: SQL Compare now correctly reads fields from indexes on a filetable when reading from a scripts folder
- SC-9479: In the summary tab, the display of columns that differ in their datatype has been made more concise
- SC-9411, SC-9180, SC-9397: SQL Compare should now correctly preserve different newline characters in user-generated SQL
12.4.2.4681 - June 7th 2017
Free Sql Compare Tool
FREQUENT UPDATES RELEASE
Features
Summary view
- We've increased the default text size, removed some extra whitespace around the top row of the results and added scrollbars to make the summary view easier to use. The summary view tab will also now stay selected when switching between different objects in the comparison.
Fixes
- SC-9475: Improved interactions around the database dropdown in the Edit Project dialog: in particular, hitting backspace will no longer clear the database name entirely. As part of this work we've removed the feature where entering a database name for a database that had the SQLSourceControl Database Revision extended property set would display the value of this extended property in the UI. This extended property is no longer set by SQL Source Control and the feature ended up causing a disproportionate amount of complexity for information that it provided.
- SC-9437: Fixed a bug which could cause some rows in the My Projects dialog to not render correctly when there were some invalid project files in the displayed folder
- SC-9457: SQL Compare now automatically applies the default filter (Filter.scpf) when registering from scripts folders or source control.
- Drop and recreate PERSISTED computed columns when changes are found, rather than rebuilding their table.
- SC-9455: SQL Compare now produces the correct existence check when renaming a table and moving it between schemas.
- SC-9403: SQL Compare no longer leaves duplicate NOCHECK statements when deploying to scripts folders
12.4.1.4639 - May 30th 2017
FREQUENT UPDATES RELEASE
Features
- The authentication type for databases (Windows/SQL Server) is now specified as a dropdown. This allows more authentication types to be added in the future.
Fixes
- SC-9404: Fixed a bug which prevented the saved sort order in the My Projects dialog from being applied correctly
- SC-9456: Fixed some high-DPI display issues in the deployment wizard 'Deployment method' settings that occurred when the windows UI scale was set to 250% or greater
- SC-9439: The 'Edit selected file' button on the 'Error parsing scripts' dialog will now correctly launch the selected editor
- SC-9271: When an error occurs updating or dropping an extended property the current transaction will now be rolled back
- SC-9429: When rebuilding a temporal table, SQL Compare no longer scripts out the HIDDEN property or default constraints on the new history table.
- SC-9443: SQL Compare now correctly scripts out DATA_COMPRESSION on temporal and memory-optimized tables
- SC-9476: SQL Compare now handles index drops correctly while disabling SYSTEM_VERSIONING.
- SC-9474: Fixed some high-DPI display issues in the deployment wizard title bar
12.4.0.4551 - May 16th 2017
FREQUENT UPDATES RELEASE
Features
- Added a summary view which will semantically explain how database objects differ
- SC-9401: SQL Compare now accepts the 'CREATE OR ALTER' syntax introduced in SQL Server 2016 SP1
Fixes
Redgate Sql Compare 12 Downloads
![Redgate sql compare 12 download download Redgate sql compare 12 download download](https://pxhst.co/avaxhome/47/13/00321347.png)
- SC-9441: SQL Compare now accepts SET syntax where a property on a CLR user-defined type is being set
- SC-9440: SQL Compare can now register multiple XML indexes on a single table with several selective XML indexes per index
Didn't find what you were looking for?