Generate DDL and DML SQL script output and execution packages
Script both objects and data from various databases simultaneously.
Script SQL Server database to a single SQL file, individual scripts, source control project, C# solution or an executable installer.
Combine objects and data from multiple SQL databases into single SQL script, installer or solution
Selectively limit what will be scripted with advanced, visual filtering
Recognize all object interdependencies, even those that even SQL Server itself fails to identify, leveraging ApexSQL’s proprietary dependency parser
Leverage the extended properties that already exist to add detail and context to your objects
Native support for Subversion, Team Foundation Server, Git, Mercurial, and Perforce
Use schema mapping to ensure error-free cross-environment migrations.
Script encrypted objects seamlessly.
Deploy SQL databases to remote clients with a single click using executable installers.
Port SQL databases to a C# solution.
Quickly map, port and label your entire database to source control.
Filter objects and data that are included in your scripts
Specify the data to be scripted down to the column level
Augment the deployment script with your own pre or post synchronization scripts
Customize script formatting, compression, installer, and many more or just use ApexSQL defaults
Set data and object grouping, column readability and multiple column sorting
Use the built in SQL editor to review and even edit scripts prior to execution