AutosyncDB

AutosyncDB by DreamTeam PRO is a solution designed to automate the process of comparing and synchronizing SQL Server database schemas, along with predefined data. This software is aimed at companies of various sizes, from small projects to large enterprises. It caters to the needs of professionals and industries including Database Administrators, Software Developers, IT Managers, Application Development Teams, and Technology Companies.

Key Features

Reduce time spent on dev, testing, and deploying to prod: According to the vendor, AutosyncDB automates the process of updating application databases, aiming to eliminate the need for manual tracking and resource-intensive methods. By using the new version of the application database as a source of sample schema and predefined data, AutosyncDB generates a synchronization script, which the vendor claims makes the update process more efficient.

Compare and synchronize SQL Server database schemas: AutosyncDB provides a solution for comparing and synchronizing SQL Server database schemas, allowing users to identify differences between database objects and build customized synchronization scripts.

Work with online databases and files: AutosyncDB supports working with both online databases and files. Users can connect to their SQL Server databases directly or work with SQL Server database backups stored as files.

Cross-server and cross-version: AutosyncDB supports cross-server and cross-version synchronization, enabling users to compare and synchronize database schemas across different SQL Server instances and versions.

Task-based and project-oriented: AutosyncDB follows a task-based and project-oriented approach, allowing users to create projects and define specific tasks within those projects. This feature aims to enhance organization and management of database schema comparison and synchronization tasks.

Build and deploy customized sync scripts: According to the vendor, AutosyncDB enables users to build customized synchronization scripts, providing flexibility and control over the synchronization process. Users can specify actions such as Create, Alter, Recreate, and Drop for different categories of database objects.

Merge predefined data: AutosyncDB supports merging predefined data along with the database schema. Users can include predefined application data in the synchronization process, ensuring that the database is up to date with the required data.

Create database update packages: AutosyncDB allows users to create database update packages that can be exported and provided to clients for client-side updates. This feature aims to simplify the process of deploying updates to client databases.

Package Wizard for client-side updates: According to the vendor, AutosyncDB provides a Package Wizard that facilitates client-side updates. Users can easily create packages for client-side updates using the wizard's intuitive interface.

Integration support for all task types: AutosyncDB offers integration support for all types of tasks, allowing users to run comparison and synchronization tasks for multiple databases on their servers. This feature aims to enhance the scalability and efficiency of the synchronization process.