ApexSQL Build 2016 R2 – Product update alert

ApexSQL Build 2016 R2 has been released

About ApexSQL Build: ApexSQL Build is a SQL database deployment tool that builds new databases and updates existing ones by packaging SQL scripts, SQL script folders, database snapshots, and scripts under version control into a single deployment SQL script, a .NET solution, or an executable installer. It allows specifying the objects to be created or updated, ensures error-free deployment, and more.

For more information visit the ApexSQL Build product page

Enhancements:

• The “Include static data” option in the Options tab and in the Static data preview step in the wizard
• CLI switches:
  • Connection options:
    • Server [/s]
    • Database [/d]
    • User [/u]
    • Password [/p]
  • Script options:
    • Script drops [/sdr]
    • Script filegroups [/sfg]
    • Script logins [/slg]
    • Script names [/snm]
    • Script collation [/sc]
    • Script ANSI options [/sao]
    • Script triggers [/str]
    • Script permissions [/sp]
    • Script extended properties [/sep]
    • Script use [/su]
    • Include transaction [/ith]
    • Comments [/cm]
    • Print statements [/ps]
    • Database script [/ds]
    • Database script type [/dst]
    • Drop if exist [/die]
    • Output script [/os]
  • Specific options:
    • Project type [/pt]
    • Output type [/ot]
    • Output name [/on]
    • Source type [/st]
    • Source name [/sn]
    • Output action type [/oat]
    • Include static data [/isd]
    • Invalid objects [/io]
    • Compatibility level [/cl]
    • Postscript file path [/postfp]
  • Source control options:
    • Source control user [/scr]
    • Source control password [/scp]
    • Source control server [/scs]
    • Source control repository [/scr]
    • Source control branch [/scb]
    • Source control project [/scj]
    • Source control label [/scl]
    • Source control folder [/scf]
  • Create database options:
    • Database directory [/dbd]
    • Database log directory [/dbld]
    • Database collation [/dbc]
    • Database recovery mode [/dbrv]
    • Database size [/dbs]
  • Help to HTML [/hth]
  • Silent [/slt]
  • Play sound upon finished operation [/be]
  • Logging level [/log]:
    • Errors
    • Warnings
    • All
    • None
  • Return error codes [/rc]
• CLI return error codes:
  • Invalid switch [2]
  • Duplicated switch [3]
  • Missing argument [5]
  • Missing a dependent switch [6]
  • Value out of range [8]
  • Invalid file path [9]
  • Invalid project file [10]
  • Unsupported edition [11]
  • Invalid activation key [12]
  • Trial has expired [13]
  • Connection timeout [14]
  • Connection failed [15]
  • Operation cancelled [17]
  • Application error [18]
  • Execution error [19]
  • Execution timeout [20]
  • Insufficient permissions [21]

Improved quality:

• 19 bugs and known issues fixed

See also:
Release notes
Download