Quest Software ApexSQL Script 2020.02.0486-0daytown

File Size: 81 MB

ApexSQL Script is a SQL tool that converts Databases into scripts, .NET EXE’s, deployment packages or into source control. Scripts are ordered based on proprietary dependency algorithms to ensure proper order of generated scripts. They can be created from Databases or Source control labels (all SCC compliant source control systems are supported) and it also includes a Command Line interface. ApexSQL Script allows a rich array of value added scripting attributes to embed customizable text, tags, dates, comments etc. into your scripts to transform your output into a richly tailored output that comes in a variety of formats.

ApexSQL Script – SQL Server scripting

Script SQL database objects and data
Create executable .NET packages to deploy objects and data
Script objects directly to Source Control
Automate SQL database migrations
SQL scripting
Script both objects and data from various databases simultaneously.

Multiple output options
Script SQL Server database to a single SQL file, executable package or a .NET solution.

SQL database versioning
Commit a specific database version or label directly to source control.

Error-free migration
Ensure that SQL databases are migrated without problems or errors using proprietary dependency analysis algorithms.

Selective SQL scripting
Specify processing criteria. Script some, most or all data and SQL objects.

Support for popular source control providers
Including Visual Source Safe, Subversion, Team foundation Server, SourceGear Vault, Perforce (soon), and Git.

ApexSQL Script Features

Source control integration – Including Git, Team Foundation Server, Microsoft Visual Source Safe, SourceGear Vault, and Apache Subversion.
FIPS support – The application is FIPS compliant
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
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 version control
Pre-impact analysis – Review the migration SQL script before it is executed
Data filtering – Quickly filter out unwanted data
Column level scripting – Specify the data to be scripted down to the column level
Custom SQL script support – Augment the deployment script with your own pre or post synchronization scripts
Seamless source control integration – Native support for Microsoft Visual SourceSafe, Subversion, Team Foundation Server and SourceGear Vault, and Git