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.
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