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.
Customer Reviews
Daniel G.
Advanced user of dbForge Schema Compare for SQL ServerTo 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.
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
Before I bought the product I had it tested and I was convinced of its usefulness
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
