What users are saying about
2 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.4 out of 100
16 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9.3 out of 100

Likelihood to Recommend

Navicat Premium

Navicat Premium is a very well-rounded tool with a reasonable licensing fee given its feature set. It is primarily suited for technical resources who must work with a variety of different database systems, but who may not be database or command line tool wizards. However, its query building and job batch scheduling feature support end-users as they build competency, and it continues to hold its value even as users outgrow their training wheels.Navicat is probably not so appropriate for DBAs and others for whom database development and management is already a career path; these folks have their preferred toolsets, both vendor-supplied and homegrown, and they might consider the additional licensing cost to outweigh the value they'd personally get out of Navicat.
Benjamin Plotkin | TrustRadius Reviewer

Redgate SQL Data Compare

If you plan to use Redgate Data Compare to automate data change between tables or SCD or similar, this is not the software that is right for you, Data Compare is a software that performs simply (but in an optimal manner) the comparison of data between tables of different databases on different environments or clone or mirror databases even on the same environment or server. Once the data is compared, you can select or deselect each line you want to update and then have the data alignment script prepared for it.
Luca Campanelli | TrustRadius Reviewer

Feature Rating Comparison

Database Development

Navicat Premium
7.5
Redgate SQL Data Compare
7.4
Version control tools
Navicat Premium
7.0
Redgate SQL Data Compare
7.0
Test data generation
Navicat Premium
7.0
Redgate SQL Data Compare
6.2
Performance optimization tools
Navicat Premium
8.0
Redgate SQL Data Compare
7.0
Schema maintenance
Navicat Premium
8.3
Redgate SQL Data Compare
8.0
Database change management
Navicat Premium
7.2
Redgate SQL Data Compare
8.8

Database Administration

Navicat Premium
7.8
Redgate SQL Data Compare
7.7
User management
Navicat Premium
8.3
Redgate SQL Data Compare
6.0
Database security
Navicat Premium
8.3
Redgate SQL Data Compare
7.0
Database status reporting
Navicat Premium
7.0
Redgate SQL Data Compare
10.0
Change management
Navicat Premium
7.4
Redgate SQL Data Compare
7.9

Pros

Navicat Premium

  • Access via standard html
  • Alert notification
Maurice Samuels | TrustRadius Reviewer

Redgate SQL Data Compare

  • Simple and easy comparison of database data. Differences can be copied or synced from one database to another with a click of a button.
  • You can save "projects" so that you can easily rerun a previous comparison whenever you need to.
  • It has a very simple, easy to learn interface. I've never needed to read any documentation or watch any tutorials in order to figure out how to do something.
Richard Davies | TrustRadius Reviewer

Cons

Navicat Premium

  • Navicat Premium's documentation can be hit-or-miss, as there are several versions available, and it's not always clear which documentation is current for the version at hand.
  • Navicat Premium's query building interface is not as easy to use or feature-rich as standard IDE and text editor tools, and I've had some issues in the most recent release build with queries auto-running in the middle of making edits, causing a lack of responsiveness in the inbuilt editor -- however, Navicat offers users the ability to edit queries via an external editor, which mitigates these issues to some degree.
  • In the data browser view, paged data navigation sometimes behaves unexpectedly or fails to work whatsoever, requiring a session restart to correct.
  • The process of saving a data export file is cumbersome, requiring navigation through several windows, and I believe it could be significantly streamlined to improve user experience.
Benjamin Plotkin | TrustRadius Reviewer

Redgate SQL Data Compare

  • Redgate SQL Data Compare is a bit slow for large text data comparison between the text fields of tables when compared to enabling SQL search engine.
  • Sometimes some characters haven't been identified and compared when comparing data between two environments.
  • It needs better customer support for utilizing the tool, and cost factor also matter.
Anonymous | TrustRadius Reviewer

Support Rating

Navicat Premium

Navicat Premium 7.0
Based on 1 answer
Very robust online community and well as excellent support staff. Easy to follow video tutorials. Detailed sample configurations are provided with guided walk-throughs via remote classroom instruction. Very fast response from support staff. No internal hires were necessary for support as vendor support staff fully met all technical expertise. 24/7 incident reporting and tracking is great.
Maurice Samuels | TrustRadius Reviewer

Redgate SQL Data Compare

Redgate SQL Data Compare 10.0
Based on 2 answers
Redgate is always fast to respond to any tickets I submit and provide fixes for any issues rapidly.
Anonymous | TrustRadius Reviewer

Alternatives Considered

Navicat Premium

While Sequel Pro is a great shareware tool, it's limited to MySQL databases; while our department does use MySQL databases, we also use Oracle databases, so Navicat Premium's multi-product support is an absolute requirement.Navicat Premium also provides data browser support, including filtering, to empower less technically-minded users to query and manipulate databases, an option not available in Sequel Pro. And the job scheduling and batching features of Navicat Premium further distinguish it above the admirable, if limited, Sequel Pro.
Benjamin Plotkin | TrustRadius Reviewer

Redgate SQL Data Compare

We have used Symantecs Database Agents for Backup Exec and Veeam's Database Backup products. Symantec does not stack up well as compared to Redgate. Veeam is a considerable contender with their SQL Server Explorer. In some scenarios I would prefer to use VEEAM over Redgate, but Redgate is a very stable product that is extremely useful.
Michael Jipping | TrustRadius Reviewer

Return on Investment

Navicat Premium

  • Similar features to OEM provided very easy to use, out-of-the-box functionality.
  • No large infrastructure changes were needed to deploy and install.
Maurice Samuels | TrustRadius Reviewer

Redgate SQL Data Compare

  • An incredible gain in terms of time
  • Speed in compiling the data update scripts
  • Ease in comparing tables
Luca Campanelli | TrustRadius Reviewer

Pricing Details

Navicat Premium

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Redgate SQL Data Compare

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Rating Summary

Likelihood to Recommend

Navicat Premium
7.4
Redgate SQL Data Compare
9.5

Support Rating

Navicat Premium
7.0
Redgate SQL Data Compare
10.0

Add comparison