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