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

Feature Set Ratings

    Database Development

    Foglight

    Feature Set Not Supported
    N/A
    7.2

    Redgate SQL Compare

    72%
    Redgate SQL Compare ranks higher in 5/5 features

    Version control tools

    N/A
    0 Ratings
    7.0
    70%
    4 Ratings

    Test data generation

    N/A
    0 Ratings
    5.0
    50%
    1 Rating

    Performance optimization tools

    N/A
    0 Ratings
    6.4
    64%
    4 Ratings

    Schema maintenance

    N/A
    0 Ratings
    9.1
    91%
    9 Ratings

    Database change management

    N/A
    0 Ratings
    8.7
    87%
    11 Ratings

    Database Administration

    Foglight

    Feature Set Not Supported
    N/A
    7.0

    Redgate SQL Compare

    70%
    Redgate SQL Compare ranks higher in 4/4 features

    User management

    N/A
    0 Ratings
    7.6
    76%
    5 Ratings

    Database security

    N/A
    0 Ratings
    5.4
    54%
    5 Ratings

    Database status reporting

    N/A
    0 Ratings
    6.4
    64%
    2 Ratings

    Change management

    N/A
    0 Ratings
    8.5
    85%
    8 Ratings

    Attribute Ratings

    • Foglight and Redgate SQL Compare are tied in 1 area: Likelihood to Recommend

    Likelihood to Recommend

    8.6

    Foglight

    86%
    6 Ratings
    8.6

    Redgate SQL Compare

    86%
    11 Ratings

    Usability

    Foglight

    N/A
    0 Ratings
    7.0

    Redgate SQL Compare

    70%
    1 Rating

    Support Rating

    Foglight

    N/A
    0 Ratings
    8.6

    Redgate SQL Compare

    86%
    6 Ratings

    Likelihood to Recommend

    Quest Software

    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.)
    Read full review

    Redgate

    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.
    Read full review

    Pros

    Quest Software

    • Foglight NMS is very light on resources given the amount of monitoring connectivity options it provides. It is one of the few that I've trialed in the past that offers SNMP v3 connections.
    • The dashboard is concise with the main areas of interest. It can be customized as well if you have a particular use case.
    • Setting up alerts is straightforward with the ability to set custom thresholds. Alert emails get sent by configuring a primary mail server with the option to add a backup mail server in the event of a primary mail server outage or connectivity issues.
    Read full review

    Redgate

    • 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.
    Read full review

    Cons

    Quest Software

    • GUI interface is difficult to navigate
    • No APM capabilities. They left this space about a year ago
    • We have had issues with the GUI response times. On a regular basis, the interface can take several minutes to refresh
    Read full review

    Redgate

    • 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.
    Read full review

    Pricing Details

    Foglight

    Starting Price

    Editions & Modules

    Foglight editions and modules pricing
    EditionModules

    Footnotes

      Offerings

      Free Trial
      Free/Freemium Version
      Premium Consulting/Integration Services

      Entry-level set up fee?

      No setup fee

      Additional Details

      Redgate SQL Compare

      Starting Price

      Editions & Modules

      Redgate SQL Compare editions and modules pricing
      EditionModules

      Footnotes

        Offerings

        Free Trial
        Free/Freemium Version
        Premium Consulting/Integration Services

        Entry-level set up fee?

        No setup fee

        Additional Details

        Usability

        Quest Software

        No answers on this topic

        Redgate

        It's a good tool to have, but becomes expensive to buy a user license for each developer.
        Read full review

        Support Rating

        Quest Software

        No answers on this topic

        Redgate

        They have a great community website where you can search for answers but are also very responsive when it comes to direct support.
        Read full review

        Alternatives Considered

        Quest Software

        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.
        Read full review

        Redgate

        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.
        Read full review

        Return on Investment

        Quest Software

        • Foglight has a positive impact on my company by being a complete monitoring platform that specializes in risk assessment, user diagnosis and management, and server monitoring ensuring a secure business infrastructure through predictive analytics, query analysis, anomaly detection, behavior tracking, troubleshooting, automated discovery, and more.
        Read full review

        Redgate

        • 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.
        Read full review

        Add comparison