What users are saying about
21 Ratings
21 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 7.7 out of 100
44 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 9 out of 100

Likelihood to Recommend

Foglight

Strengths [Foglight]
  • Monitoring, Alerting and Management of on-prem virtualization and physical servers
  • Historical trending and baselining are excellent and being able to compare a problem period against the same sets of data for a period when there was no issue is especially helpful as part of troubleshooting.
  • Ease of use for end users is appreciated
Weaknesses [of Foglight]
  • Creation and management of custom monitors is a developer level activity requiring Groovy skillset
  • Less useful for management of an environment where there is a large amount of custom implementations
  • Commitment to longevity of cartridges/packs for specific subsystems
  • Ability to create custom schedules/alerts/escalations is only available via a 3rd party product (from a former Quest developer) and is not particularly easy to manage/manipulate
  • Lack of API accessibility for external integrations to other analytics (splunk, etc.)
Anonymous | TrustRadius Reviewer

Redgate SQL Compare

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.
Kevin R. Zakoski | TrustRadius Reviewer

Feature Rating Comparison

Database Development

Foglight
Redgate SQL Compare
7.3
Version control tools
Foglight
Redgate SQL Compare
7.0
Test data generation
Foglight
Redgate SQL Compare
5.0
Performance optimization tools
Foglight
Redgate SQL Compare
6.5
Schema maintenance
Foglight
Redgate SQL Compare
9.0
Database change management
Foglight
Redgate SQL Compare
8.8

Database Administration

Foglight
Redgate SQL Compare
7.5
User management
Foglight
Redgate SQL Compare
8.2
Database security
Foglight
Redgate SQL Compare
7.1
Database status reporting
Foglight
Redgate SQL Compare
6.5
Change management
Foglight
Redgate SQL Compare
8.4

Pros

Foglight

  • Database monitoring
  • Database management suite
  • Customization (both monitors and dashboards)
Aletha Diaz | TrustRadius Reviewer

Redgate SQL Compare

  • 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.
Richard Davies | TrustRadius Reviewer

Cons

Foglight

  • While the Linux agents mostly work out of the box with the remote node receiving the push, some newer Linux distributions may require some tweaking of the agent install script due to upstream software package changes.
  • The canned reports are adequate for high-level overviews but I would like to be able to further customize them to include specific information from the monitored nodes.
  • I wish there was an application to migrate the Foglight NMS application and database (which reside on the same server) to a new server or VM. They make you open a support case to accomplish that for which you need an active maintenance contract.
Roger Mialkowski | TrustRadius Reviewer

Redgate SQL Compare

  • 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.
Rob Cowart | TrustRadius Reviewer

Usability

Foglight

No score
No answers yet
No answers on this topic

Redgate SQL Compare

Redgate SQL Compare 7.0
Based on 1 answer
It's a good tool to have, but becomes expensive to buy a user license for each developer.
Anonymous | TrustRadius Reviewer

Support Rating

Foglight

No score
No answers yet
No answers on this topic

Redgate SQL Compare

Redgate SQL Compare 8.9
Based on 5 answers
They have a great community website where you can search for answers but are also very responsive when it comes to direct support.
Anonymous | TrustRadius Reviewer

Alternatives Considered

Foglight

We were previously using Oracle to monitor resources across servers and networks. In general, that product was alright but the Foglight alerts are far superior to Oracle. The business goal of using Foglight is really to minimize business interruption costs so the faster and more noticeable the alerts, the better the product is at solving our problems.
Jaime L. Regan | TrustRadius Reviewer

Redgate SQL Compare

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.
Josh Sayers | TrustRadius Reviewer

Return on Investment

Foglight

  • Great value for vmWare monitoring.
  • Helps our eCommerce team to troubleshoot issues and make end user experience better.
Anderson Costa | TrustRadius Reviewer

Redgate SQL Compare

  • Makes deployment fairly simple. Cutting our deployment time down.
  • With the SDK, we can customize our deployment process very quickly and easily.
  • History is not great, it does create scripts you can go back and see but it would be nice to have a quicker version view by object to save time.
Steven Gockley, MBA, MCSA | TrustRadius Reviewer

Pricing Details

Foglight

General

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

Redgate SQL Compare

General

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

Rating Summary

Likelihood to Recommend

Foglight
8.0
Redgate SQL Compare
8.7

Usability

Foglight
Redgate SQL Compare
7.0

Support Rating

Foglight
Redgate SQL Compare
8.9

Add comparison