ApexSQL Build

Manual database creation can take a long amount of time, especially if it contains a lot of objects and fields that need to be properly customized.

On the other hand, if you have the SQL script containing all the required details, you can use a software utility that automatically transforms it in a completely functional database.

ApexSQL Build is an application that allows you to easily generate and deploy databases for Microsoft SQL Server, along with the required objects and necessary fields. In order to create one, all you have to do is select the SQL script from your computer and specify the desired properties of the output result.

These properties include the database name, output directory for both the file and the log, as well as the collation format and recovery mode. The compatibility mode can be used to optimize the database in accordance to the version of SQL Server installed on your computer. All of these settings can also be automatically taken from the input source, in case you do not want to bring any modifications.

Before you start the build process, you can choose the objects to be included from the SQL script, in order to drop those that you do not require. These objects are grouped by role or schema and you can manually select the ones you want to keep. After the database is created, you can execute additional scripts by adding them in the order you want them to be run.

ApexSQL Build enables you to deploy the scripts in a variety of ways, such as C# projects or .NET executable file, which can easily be exported and used on different computers. The application is also capable of updating and executing scripts on multiple databases at once.

The multitude of script customization options and the possibility to package them in a number of different ways make ApexSQL Build a handy application that can greatly speed up the database building process. The wizard-based offers you complete control over all the aspects of your databases, including objects and related scripts.