ApexSQL Script

ApexSQL Script is a SQL Server database migration tool which scripts database object and data into a single or multiple deployment SQL scripts, C# projects, and executable deployment packages. It can export live databases directly to source control and can automate and schedule the migration process unattended. Some features include: SQL database scripting, SQL database versioning, multiple output options, and Error-free migration. Posibility to save project as batch script for automatic execution.

Features:

- Visual object filtering: Selectively limit what will be scripted with advanced, visual filtering

- Recognizes and accurately processes all objects' interdependencies

- Extended properties editor: Leverage the extended properties that already exist in your SQL database to add detail and context to your objects. Edit these descriptions inline without leaving the tool

- Smart schema mapping: Employ schema mapping to ensure error-free cross-environment migration

- Transparent decryption: Script encrypted objects seamlessly

- Streamlined options

- Customizable display options

- Simultaneous processing: Combine objects and data from multiple SQL databases in a single SQL script, installer or solution

- Database installers: Deploy SQL databases in a single click using executable installers

- Deployment packages: Seamlessly port SQL databases to a .NET solution

- SQL database builds: Export databases directly to source control

- SQL Server 2016, 2014, 2012, 2008R2, 2008, and 2005 support

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

- Compatibility level option for database scripting

- Save project as batch script

- Object filter