ApexSQL Script

SQL Script Generation

Generate DDL and DML SQL script output and execution packages

• Script both SQL database objects and data
• Create executable installation packages
• Script objects directly to a source control project
• Automate SQL database scripting and migrations
• Integrate with all popular SC systems e.g. Git, SVN
• 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.

Multiple output options

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

Multi-database processing

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

Visual object filtering

Selectively limit what will be scripted with advanced, visual filtering

Accurate dependencies

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

Extended properties editor

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

Source control integration

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

Schema mapping

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

Transparent decryption

Script encrypted objects seamlessly.

Database installer

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

Deployment packages

Port SQL databases to a C# solution.

Export to source control

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

 

Data filtering

Filter objects and data that are included in your scripts

Column level scripting

Specify the data to be scripted down to the column level

Custom SQL scripts

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

Customizable scripting options

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

Display options

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

Native IDE

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