Navicat Premium is a multi-connection database development and administration tool which can simultaneously connect 7 databases (MySQL, MariaDB, MongoDB, SQL Server, Oracle, PostgreSQL, and SQLite) from a single application. Compatible with cloud databases like Amazon RDS, Amazon Aurora, Amazon Redshift, Microsoft Azure, Oracle Cloud, Google Cloud, Alibaba Cloud, Tencent Cloud, MongoDB Atlas and Huawei Cloud, developerws can quickly and easily build, manage and maintain databases.
N/A
Redgate SQL Toolbelt Essentials
Score 8.2 out of 10
N/A
Redgate's SQL Toolbelt Essentials includes industry-standard tools for SQL Server development & deployment, enabling users to include SQL Server databases in agile processes and enabilng developers to embed robust and scalable development practices.
N/A
Pricing
Navicat
Redgate SQL Toolbelt Essentials
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
Navicat
Redgate SQL Toolbelt Essentials
Free Trial
No
Yes
Free/Freemium Version
No
No
Premium Consulting/Integration Services
No
No
Entry-level Setup Fee
No setup fee
No setup fee
Additional Details
—
—
More Pricing Information
Community Pulse
Navicat
Redgate SQL Toolbelt Essentials
Features
Navicat
Redgate SQL Toolbelt Essentials
Database Development
Comparison of Database Development features of Product A and Product B
Navicat
8.2
Ratings
4% below category average
Redgate SQL Toolbelt Essentials
-
Ratings
Version control tools
7.00 Ratings
00 Ratings
Test data generation
8.20 Ratings
00 Ratings
Performance optimization tools
8.00 Ratings
00 Ratings
Schema maintenance
9.20 Ratings
00 Ratings
Database change management
8.80 Ratings
00 Ratings
Database Administration
Comparison of Database Administration features of Product A and Product B
I was tasked with migrating data from our local PostgreSQL DB to an Amazon RDS instance. I expected this to be a difficult job, but Navicat's migration wizard made it fairly straightforward. I think that it's more geared towards professional users, although not necessarily database practitioners. Non pros might do better with the new Navicat Lite edition.
We use SQL Compare to troubleshoot performance problems quite a bit since our data model is more like a template and not everything is 100% in sync and customization occurs between different client databases. We continually get pulled into performance issues and the developers will say Client A is performing different than Client B, why? Using SQL Compare, we usually find that one client was tuned and had indexes altered or added that weren't deployed to all clients or other objects weren't deployed correctly during the release. On the other hand, since our data model practices allow client databases to drift I tried to create a new golden image by trying to compare multiple databases based on the same data model and found it to be a very difficult process to complete using SQL Compare. SQL Compare gave me too much information and doesn't allow enough filtering to eliminate a lot of the noise.
Simple and easy comparison of database schemas and 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.
Pricing.... I wish there was an inexpensive developer version I could buy for myself.
Portability.... I would like to use it from a flash drive so I can use it where ever I am asked to work.
Unbundled.... This may be available already but I dont' recall I can buy it cheaply as a stand-alone product. Its only part of the bundle - cost effectively.
There is quite a lot to learn because Navicat Premium is a very comprehensive database management and development tool, but it's User Interface is intuitive enough to pick up fairly quickly. I have also referred to the documentation on occasion, and can attest that it is quite good. I feel that it works best on a large monitor, but that's fairly common for this sort of software.
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.
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.
I've used Visual Studio Database Projects for this type of work in the past with some success, but Redgate SQL Compare is faster, more transparent, and simply easier to use. Faster is self explanatory. More transparent, means that it's much easier to set up your desired options for schema change deployment scripts. Easier to use, It's really dead simple. Start a project, connect your source, connect destination, click compare.
