ApexSQL Script 2016.01
pexSQL 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