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, .NET solutions or executable installers. It can export live databases directly to version control and can automate and schedule the migration process unattended. Some features include: SQL database scripting, SQL database versioning, Multiple output options, Error-free migration.
Features:
- SQL Server 2012 support: Script SQL Server 2012 databases, data objects and properties including FileTables, sequences, search property lists, columnstore indexes, poison message handling attribute for queues as well as geometry and geography auto grid tessellation scheme for spatial indexes
- 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
- Scripting wizard improvements
- 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
- More intuitive interface: Easier access to all commonly used commands
- Improved project management: Save your options to a project for instant re-execution
- Streamlined options
- Customizable display options
- Diamond docking
- 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 version control