dbForge Schema Compare for SQL Server

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.

Languages supported: English

10.0/10 (Expert Score) ★★★★★
Product is rated as #4 in category Database Comparison Software
Ease of use
Support
Ease of Setup

Images

Check Software Images

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.

dbForge Schema Compare for SQL Server
dbForge Schema Compare for SQL Server

Show more categories

Customer Reviews

dbForge Schema Compare for SQL Server Reviews

Daniel G.

Advanced user of dbForge Schema Compare for SQL Server
★★★★★
I am a software developer and work for many companies

What do you like best?

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.

What do you dislike?

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

Recommendations to others considering the product:

Before I bought the product I had it tested and I was convinced of its usefulness

What problems are you solving with the product? What benefits have you realized?

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 source: G2.com

Leave a reply

Your total score

B2B Software Guide