ApexSQL Script

SQL Server scripting

Script SQL objects and data into scripts and deployment packages

?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

Multiple output options

Script SQL Server database to a single SQL file, individual scripts, executable package or a .NET solution

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 .NET 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

System requirements

Hardware requirements Dual Core 2.0 GHz CPU

 3 GB memory

 47 MB disk space 

SQL Server Microsoft SQL Server 2016, 2014, 2012, 2008, and 2005

 Azure SQL Database 

OS Windows Vista/Server 2008 and above

Required  Microsoft .NET Framework 4.5 

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

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.

Save a bundle

 

ApexSQL Script is included in ApexSQL Developer

?14 ApexSQL developer tools

?Priority support

?1 year free support and upgrades

?New products added for free

?Combined 75% savings