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 installation 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. Possibility 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, executable installer or C# solution
• Database installers: Deploy SQL databases in a single click using executable installers
• Deployment packages: Seamlessly port SQL databases to a C# solution or executable installer
• SQL database builds: Export databases directly to source control
• Support for SQL Server 2016, 2014, 2012, 2008R2, 2008, and 2005
• Native support for Git, Subversion, Team Foundation Server, Mercurial, and Perforce
• Compatibility level option for database scripting
• Save project as batch script
• Object filter