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
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.
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
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
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.
Export to source control
Quickly map, port and label your entire database to source control.
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
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