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

March 9, 2017