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.