Build SQL databases
Create SQL databases and deployment packages from scripts, snapshots, and source control
?Run scripts on multiple databases at once
?Create executable installation packages
?Deploy databases directly from SQL source control
?Consolidate multiple SQL scripts
?Build databases from scripts, source control, etc
?Ensure error free deployments
?Preview the script impact by action or SQL object
?Execute scripts on saved list of servers/databases
Features
Multi-database script execution
Execute SQL script against multiple databases at the same time.
Source control integration
Build and upgrade SQL databases directly from source control including Git, Mercurial, Perforce, Subversion, and Team Foundation Server.
Database installers
Deploy SQL databases in a single click using executable installers
Build packages
Deploy SQL databases across remove environments using C# projects / .NET executables.
Deployment scripts
Combine multiple objects scripts into a single deployment or upgrade SQL script
Accurate dependencies
Recognize all objects interdependencies; even the ones SQL Server itself fails to identify.
System requirements
Hardware requirements Dual Core 2.0 GHz CPU
3 GB memory
69 MB disk space
SQL Server Microsoft SQL Server 2016, 2014, 2012, 2008, and 2005
Azure SQL Database
OS Windows Vista/Server 2008 and above
Required Microsoft .NET Framework 4.5
Note Native support for the x64 architecture
Native support for Git, Mercurial, Perforce, Subversion, and Team Foundation Server
ApexSQL Build |
Redgate SQL Packager |
Redgate SQL Multi Script |
|
Systems | |||
Live database | |||
SQL Express database | |||
SQL Azure database | |||
Outputs | |||
Direct database execution | |||
Database installer packages (e.g. Executable installer, C# solution) | |||
T-SQL deployment script | |||
Inputs | |||
Individual script file | |||
Proprietary schema snapshot | |||
Scripts folder | |||
Source control project or label | |||
Direct database comparison result | |||
Features | |||
Post deployment scripts | |||
Other | |||
Command Line Interface | |||
Source control label support | |||
Use cases | |||
Create database installers for remote updates | |||
Simultaneous script execution on multiple databases | |||
Consolidation of multiple scripts | |||
Refactoring existing scripts for execution order |
© Copyright 2000-2023 COGITO SOFTWARE CO.,LTD. All rights reserved