Version 11, which includes the latest schema comparison framework, is now available.
Click here to learn more about the new and updated features.
from
$699

What is Builder for SQL Server?

Builder is a tool that allows you to push schema changes from a central database to one or multiple client databases. Client databases might be disconnected from the central database, they could be running different version of SQL Server, they could be hosted on-premise or on Azure.

The end product of Builder is an executable package with the schema updates embedded in it. When the package runs on the client machines, it compares the database on the machine with a snapshot of the master database embedded in it, identifies schema differences between the two and synchronize them.

Builder is designed to run by users with little database experience. The package, that Builder generates, is self-contained, with no external dependencies other than the .NET framework. All resources that Builder needs to synchronize the client database are embedded in this package.

Simple, ready to deploy

Designed to be solve a specific problem, synchronizing user databases with a master copy, Builder performs this task with simplicity:
  • It provides a wizard-based interface allows you to easily navigate through the whole process.
  • The end product that you ship to your user is just one executable package.
  • The executable package contains all the resources it needs embedded in it, including our comparison libraries and a snapshot of the master database.

Plenty of options

YOu have plenty of options to choose from, in order to accommodate even the most challenging scenarios:
  • You have the option to create a user database that doesn't exist and various methods to accomplish it.
  • You can run custom scripts, before or after the schema synchronization.
  • You can log everything, such as schema changes, operational messages and synchronization errors.
  • You can also get email notifications based on the outcome of the synchronization process.

Customizable

When the default options are not sufficient, Builder allows even further customizations, including the actual code that synchronizes databases:
  • You can modify the c# code that synchronizes a user database with the master copy. The source code with samples, for the most typical scenarios, are installed with the Builder.
  • You can automate the Builder process by using its command line, instead of the wizard-based interface.
  • You can override package settings at a client machines using the package parameters.

How does the Builder work?

Builder is designed to be simple and easy to use. You start with a wizard-based interface that allows you to complete the entire process step by step, such as:
  • The master database: This is the database whose schema will be pushed to the client databases.
  • Client databases: You can synchronize a client database that exists or needs to be created new. If you choose to create the database, you have the option to create a standard blank database, create it from a custom SQL script or from a SQL Server backup.
  • Custom scripts: These are optional T-SQL scripts that run before or after the synchronization.
  • Notifications: Builder can send you an email notification when it completes, succeeds or fails.
  • Logging: You specify the log files and the logging options.
At the end of the wizard, Builder generates an executable package, with all resources embedded in it. You send this package to your user to let them synchronize their databases with the master copy.
SQL Server Gold Subscription
1-Year
$699
Gold Subscription contains these tools:
  • Builder for SQL Server
  • Schema and Data Compare for SQL Server
  • Schema Compare SDK for SQL Server
  • Script Executor for SQL Server, DB2, MySQL
  • RSS Reporter for SQL Server
  • Access to all patches and major releases
  • Priority support via email
Builder Only
Perpetual, Lifetime License
$799
  • Contains Builder for SQL Server
  • Latest patches and releases are available with a maintenance plan
  • Includes standard support via email

Technical Information

Version

Version number: 11.0.0.0
Version date: December 12, 2019
To view the change history, click here.

SQL Server Supported

Builder supports SQL Server from 2005 to 2019, including the latest Azure Databases.

Requirements

Builder for SQL Server requires .NET framework 4.6 or higher installed.

Online Help

Click here to view the Builder online help.

Software License Agreement

Click here to view the Software License Agreement.