For the best web experience, please use IE11+, Chrome, Firefox, or Safari
Free Trials Request Pricing
Home / SQL create database automation

SQL create database automation

ApexSQL Build is a SQL Server development tool that can build databases, scripts or executable installers from SQL scripts, scripts folders, snapshots or source control projects. ApexSQL Build also supports database builds for SQL Azure Databases and Amazon RDS for SQL Server.
An introduction to ApexSQL Build 08:07
Download Free Trial

Nav Menu

SQL create database automation

Benefits

  • Create executable installation packages

  • Consolidate multiple SQL scripts

  • Ensure error free deployments

  • Deploy databases directly from SQL source control

  • Build databases from scripts, source control, etc

  • Preview the script impact by action or SQL object

Features

Source control integration

Build and upgrade SQL databases directly from source control, including Git, Mercurial, Perforce, Subversion, and Team Foundation Server. Learn more

Database installers

Deploy SQL databases in a single click using executable installers

Build packages

Deploy SQL databases across remote environments using a C# solution or executable installers. Learn more

Deployment scripts

Combine multiple objects scripts into a single deployment or upgrade SQL script. Learn more

Accurate dependencies

Recognize all objects interdependencies, even the ones SQL Server itself fails to identify. Learn more

Customizable properties

Provide properties for the newly deployed database

Custom script support

Augment the deployment package with your own post-deployment script. Learn more

Transparent decryption

Create or update databases containing encrypted objects

Customizable builds

Deploy some, most, or all of your objects. Learn more

Export data source

Export databases to snapshots, scripts, or directly to source control

Full Command Line Interface support

Automate deployment processes unattended. Learn more

Include static data

Insert static (aka lookup) data into selected tables

Visual themes

Customize the visual appearance with interface themes. Learn more

Related Topics

ApexSQL Build 2018 – Screen shot tour

ApexSQL Build 2018 – Screen shot tour

This article represents a screen shot tour of ApexSQL Build features with a brief description
How to customize the SQL Server database objects to be deployed in a database build process

How to customize the SQL Server database objects to be deployed in a database build process

This article describes how to prepare a detailed object analysis for building a database or for a database update deployment, how to customize the SQL database objects and include dependent objects automatically
How to build a SQL database from source control without dependency problems

How to build a SQL database from source control without dependency problems

This article describes how to use ApexSQL Build to make sure there aren't any dependency problems when deploying a SQL Server database from source control
How to create a SQL build script from the source control repository

How to create a SQL build script from the source control repository

This article describes how to create a database from a specific version of DDL scripts stored in a source control system, using ApexSQL Build
How to consolidate multiple SQL scripts into a single SQL script

How to consolidate multiple SQL scripts into a single SQL script

This article describes how to use ApexSQL Build and its Consolidate scripts feature to combine multiple SQL scripts into a single SQL script in a very simple way
How to re-order scripts to avoid dependency based errors

How to re-order scripts to avoid dependency based errors

This article provides details on how to execute the object scripts in a correct order, to avoid dependency based errors
How to build a SQL Server database from source control

How to build a SQL Server database from source control

This article describes how to use ApexSQL Build to pull out the database (which you previously versioned in source control), and recreate it in a QA environment
ApexSQL Build Command Line Interface (CLI) switches

ApexSQL Build Command Line Interface (CLI) switches

This article explains the ApexSQL Build CLI switches, and their usage through the examples

Testimonials

Clinical NetwoRx

I have worked for 18 yrs as a developer and for the past 5 yrs I have been an application manager, never have I seen a prompt response in my career. Worked with tons of products most of them not as good, but kudos to you man, you have got a great product and promising support.

Trenton D Souza Application Manager, Clinical NetwoRx

John Saunders

Thanks for great products!

John Saunders Microsoft MVP, Connected System Developer

ApexSQL Build is part of the ApexSQL DevOps toolkit

Learn More
ApexSQL DevOps toolkit

Get started now

Create a SQL database from any input and automate builds from source control.
Download Free Trial