We are a dev team that has been working together since the first half of the 2000s. Most of our projects are related to business process automation using Microsoft SQL Server as the main relational data store.
Back in 2001, we faced the problem of updating client databases. Every month for an ERP project we were working on, more than 70 new tables could be created, 4 times more procedures, functions and triggers, even more indexes and many changes to existing functionality. That is when we started to pursue the goal of automating client database updates and came up with the idea of creating our own tool for synchronizing database schemas.
As conceived, the developer has to care only of those changes that cannot be made automatically, such as data manipulation, dealing with incompatible changes to column data types, renaming tables, columns, and so on. And the next idea was to add support to migrate the predefined application data. Thus, since the development of this tool, we were only interested in DDL scripts and the scripts for inserting predefined data to create a sample version database, as well as small prep and final scripts for making some special changes. It's all. No more huge update scripts, no more their management, no more related errors.
AutosyncDB is our second solution in this area. We have gathered both comparison and synchronization of database schemas and synchronization of predefined data under one roof. The tool is easy to use, to customize, to integrate.
We hope you enjoy AutosyncDB and it will be a reliable assistant for you at all stages, from development and testing to deployment in production.