You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

 
Script both SQL database objects and data
Create executable installation packages
Script objects directly to Source Control
Automate SQL database scripting and migrations
Integrate with popular source control systems
Script an entire server down to individual columns
Save customized scripting profiles as projects
Easily decrypt some/all encrypted database objects

Features

SQL scripting

Script both objects and data from various databases simultaneously. Learn more

See next feature

Multiple output options

Script SQL Server database to a single SQL file, individual scripts, source control project, C# solution or an executable installer. Learn more

See next feature

Multi-database processing

Combine objects and data from multiple SQL databases into single SQL script, installer or solution

See next feature

Visual object filtering

Selectively limit what will be scripted with advanced, visual filtering

See next feature

Accurate dependencies

Recognize all object interdependencies, even those that even SQL Server itself fails to identify, leveraging ApexSQL’s proprietary dependency parser

See next feature

Extended properties editor

Leverage the extended properties that already exist to add detail and context to your objects

See next feature

Source control integration

Native support for Subversion, Team Foundation Server, Git, Mercurial, and Perforce. Learn more

See next feature

Schema mapping

Use schema mapping to ensure error-free cross-environment migrations. Learn more

See next feature

Transparent decryption

Script encrypted objects seamlessly. Learn more

See next feature

Database installer

Deploy SQL databases to remote clients with a single click using executable installers. Learn more

See next feature

Deployment packages

Port SQL databases to a C# solution. Learn more

See next feature

Export to source control

Quickly map, port and label your entire database to source control. Learn more

See next feature

Data filtering

Filter objects and data that are included in your scripts

See next feature

Column level scripting

Specify the data to be scripted down to the column level

See next feature

Custom SQL scripts

Augment the deployment script with your own pre or post synchronization scripts

See next feature

Customizable scripting options

Customize script formatting, compression, installer, and many more or just use ApexSQL defaults

See next feature

Display options

Set data and object grouping, column readability and multiple column sorting

See next feature

Native IDE

Use the built in SQL editor to review and even edit scripts prior to execution

See next feature
 

ApexSQL Script 2018 – Screen shot tour

This article represents a screen shot tour of ApexSQL Script features with a brief description

SQL Server bulk copy and bulk import and export techniques

This article explains how to copy large amounts of data from one table or set of tables to other databases

How to script encrypted SQL database objects

This article describes how to use ApexSQL Script to script encrypted objects seamlessly like any other non-encrypted object

How to script SQL Server database users with roles

This article describes how to use ApexSQL Script to script database users, with their membership in their respective database roles, in few steps without the need to be familiar with the system database tables

How to automate batch SQL object scripting and committing to source control

This article describes how to script each SQL object to an individual .sql file and commit it to the source control

Transfer SQL logins for users with a large number of SQL-authenticated logins

This article describes how to transfer SQL logins using the Copy Database Wizard, the Script Login As method, the script published in Microsoft's KB article, and ApexSQL Script

Script a database for specific DML records only

This article describes how to easily script specific data and move it from one table to another using ApexSQL Script

How to combine objects and data from multiple SQL databases in a single SQL script

This article explains how to use ApexSQL Script to create a single script from multiple sources, making it easy to apply to the target environment or the source control

How to commit SQL Server table static data to a source control repository

This article explains how to use ApexSQL Script to commit static data from a SQL database to the source control repository, either manually (commit via the GUI) and automatically (via the CLI)

How to create DDL and DML SQL scripts for specific SQL database objects only

This article explains how to use ApexSQL Script to create DML and DDL SQL scripts, making it an easy task even if it is performed repeatedly and frequently

How to export a SQL database directly to source control

This article shows how to use ApexSQL Script to export complete SQL database, or just a couple of its objects, to one of the common source control system providers

ApexSQL Script Command Line Interface (CLI) switches

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

How to narrow the data sub-set for object scripting

This article presents several techniques on how to narrow down the data in the scripting process

See more
Community Standard Professional
SQL Server version
      SQL Server 2005 – 2017
SQL Server editions
      Express
      Standard
      Enterprise
Cloud
      Azure SQL Database
      Amazon RDS for SQL Server
Inputs
      SQL Server database
Outputs
      SQL script
      Scripts folder
      Source control project or label
      Database installer packages (e.g. Executable installer, C# solution)
Features
      Column level scripting
      Customizable scripting options
      Extended property editor
      Object filtering
      Schema mapping
      Script encrypted objects
      Where clause filtering
Pre-scripting options
      Including object dependencies for scripting
      Pre and post synchronization scripts
Source control system support
      Git
      Mercurial
      Perforce
      Subversion
      Team Foundation Server
Other
      Integrated SQL script editor
      Projects
      Save project as automation script
Use cases
      Combine objects and data in single SQL script
      Create DDL and DML SQL scripts for specific SQL database objects only
      Script a database for specific DML records only
      Script encrypted SQL database objects
      Script multiple databases simultaneously
      Script SQL Server database users with roles
      SQL Server bulk copy and bulk import and export
      Transfer SQL logins for users with a large number of SQL-authenticated logins
      Automatically script SQL Server table data and object schema directly to source control
      Commit SQL Server table static data to a source control repository
      Create SQL database executable installer
Interface
      GUI themes
      High DPI and 4K resolution support 2018 R3 2018 R3 2018 R3
      Microsoft standard iconography, colors and other visual effects
      Command line interface
Price
Free $249 $399

Testimonials

I want to congratulate you on an excellent product [ApexSQL Script]. It has done all we need and more. In the future, I will look here first for tools. Keep up the good work

Patrick Escarcega

Laucks Testing Laboratories, Inc.

Great tool - we use ApexSQL Script for every production build at our company and it is a key component of our build process

Max Pilipis

Sr. Software Engineer

Academic Management Services

ApexSQL Script is a nifty, easy to use utility ..

Brad M. McGehee

SQL-Server-Performance

I've found ApexSQL Script to be an invaluable tool to quickly do a job that would've taken me hours previously to accomplish. I found myself using the tool so much that I finally created a shortcut on my sacred desktop to it

Brian Knight

SQLServerCentral

ApexSQL Script is part of the

ApexSQL DevOps toolkit

Volume pricing

Standard

1

$249

2-4

$199

5-9

$174

10-19

$149

Professional

1

$399

2-4

$319

5-9

$279

10-19

$239

Save a bundle

ApexSQL Script is included in ApexSQL Developer

All 20 ApexSQL developer tools

Priority support

1 year free support and upgrades

New products added for free

Combined 80%+ savings