It's been two months since this profile received a new review

dbForge Schema Compare for SQL Server Reviews & Product Details

dbForge Schema Compare for SQL Server is a reliable tool that saves your time and effort when comparing and synchronizing databases on SQL Server. The tool allows working with live SQL Server databases, snapshots, and backups. You can quickly compare your SQL Server databases, analyze differences and perform error-free schema synchronization using generated SQL scripts. Supports SQL Server 2022. Features: - Supported Data Sources -Supported Schema Objects - Non-Schema Object Comparison -T-SQL Code Comparison - Version Control Integration - Synchronization - Analysis of Comparison Results - Export of Comparison Reports - Routine Tasks Automation - Integration with SSMS - Schema Compare in DevOps

Seller

Devart

Discussions

dbForge Schema Compare for SQL Server Community

Languages Supported

English

Product Description

dbForge Schema Compare for SQL Server is a tool for comparing and synchronizing Microsoft SQL Server database schemas using generated SQL script in a well-designed user interface quickly and without errors.

Overview by

Jordan Sanders (PR Manager at Devart)

Pricing

Pricing provided by dbForge Schema Compare for SQL Server.

Subscription Standard 1 year

$219.95

Subscription Professional 1 year

$269.95

View More Pricing Information

Top-Rated Alternatives

View All Alternatives

dbForge Schema Compare for SQL Server Media

T-SQL code comparison

Schema Comparison Result Analisys

Export Comparison Report

Non-Schema Object Comparison

Routine Task Automation

Scripts folder and version control integration

G2 reviews are authentic and verified.

Here's how.

BG

Bhavana G.

Cloud Engineer

Enterprise (> 1000 emp.)

11/17/2021

"dbForge Schema Compare for our organization's SQL Servers"

4/5

What do you like best about dbForge Schema Compare for SQL Server?

dbForge Schema Compare allows me to compare and synchronize SQL databases through its object explorer pannel. it incorporates versions within singular source control, which is fabulous. It provides carious add-in bundles, which ensure the proper schema comparison necessaires are check checkboxed for installation. Review collected by and hosted on G2.com.

What do you dislike about dbForge Schema Compare for SQL Server?

None actually. I do the setup & pre-requisites for my schema comparison in my organization with ease. It provides simple configuration features which automatically generates relation of table mapping, how to map the schemas, and also compare different database definitions. Review collected by and hosted on G2.com.

What problems is dbForge Schema Compare for SQL Server solving and how is that benefiting you?

The source and target of the comparison in our SQL server and connected, and the comparison results appear as a set of actions that ought to be handled with a target for effective comparison. For this, dbForge Schema Compare gives me various filter, group, and object sorting in its results. It has a splendid dashboard which is very useful to comapre and aslo keep a detached window in a different screen for comprehensive insights. It's has a brilliant backup feature where I can quickly take snapshot and evaluate the diversities with its schema synchronization capabilities for our SQL Servers. Review collected by and hosted on G2.com.

DG

Daniel G.

Enterprise (> 1000 emp.)

9/27/2018

"I am a software developer and work for many companies"

5/5

What do you like best about dbForge Schema Compare for SQL Server?

To be able to make the comparison of the scheme automatically after the synchronization process has finished to make sure everything went well.

Configuration of the different accesses to databases in such a way that when I have to make a comparison, I only choose the origin and destination of the already configured list of accesses. Review collected by and hosted on G2.com.

What do you dislike about dbForge Schema Compare for SQL Server?

There are no specific things that I do not like, maybe the product could be improved by adding different configuration options for the default values related to specific comparisons Review collected by and hosted on G2.com.

Recommendations to others considering dbForge Schema Compare for SQL Server:

Before I bought the product I had it tested and I was convinced of its usefulness Review collected by and hosted on G2.com.

What problems is dbForge Schema Compare for SQL Server solving and how is that benefiting you?

I have been using the tool for a year

It is fundamental for my work since I am a software developer and in my development environment I make many modifications to the database structure of the applications and previously had the problem that I had to build SQL scripts to update the schema in my clients . This task took me a long time and sometimes I made mistakes or forgetfulness.

Now with the ability to generate a script to run on the client that problem is solved and do not waste time or effort in doing that work that in itself, is cumbersome.

In some clients I have VPN access to the client's database servers and in some cases I execute the script on my client directly. I do this out of hours and I make sure that the application is updated in the production environment.

For clients that do not allow me to access their servers, we only send them the script for a DBA to execute.

The good thing about the generated script is that if there is a problem, it automatically "Rollback" everything done without ruining the structure of the database.

In addition, the tool allowed me to modify the "Collation" of specific elements of the structure that had been generated from the start.

Summing up: For me this tool is fabulous because it gives me the total security that the change in the scheme is made with success, thus ensuring in my clients the changes I need.

uration for default values relating to specific comparisons Review collected by and hosted on G2.com.

JB

Jeff B.

Vice President of Technology

Computer Software

Mid-Market (51-1000 emp.)

9/27/2018

"A Critical Part of our CI Pipeline"

5/5

What do you like best about dbForge Schema Compare for SQL Server?

dbForge Schema Compare can be called from the command line. This means we can integrate it into our CI pipeline. An important part of our development process is synchronizing production schemas with our development schemas and the application's ORM. Using this tool, we can automate that process. It produces delta's for both schema and records that become part of the sprint's build. I have looked at many different products and tools that do this, and this is the only one that ticks all the boxes and is reasonably priced. Review collected by and hosted on G2.com.

What do you dislike about dbForge Schema Compare for SQL Server?

We wish this ran under Linux, as our systems are pretty much all Linux. Because it doesn't run under linux, we have to have this script run on a Windows box. It turns out not to be such a big deal.

One other thing is that there have been bugs in the past that have taken quite a while for the vendor to fix. Eventually they were fixed, however. Review collected by and hosted on G2.com.

Recommendations to others considering dbForge Schema Compare for SQL Server:

Try it out on your actual schemas with the kinds of deltas that you actually do. I have looked at a lot of these tools and they all approach this problem is slightly different ways. Review collected by and hosted on G2.com.

What problems is dbForge Schema Compare for SQL Server solving and how is that benefiting you?

Synchronizing production and development schemas for each new build of our product. Review collected by and hosted on G2.com.