DatabaseDeploy

The DatabaseDeploy utility is used to create a new database or to update an existing database to the latest version.

Note:

You can also run the utility in a batch of commands. If the database creation/upgrade is successful, the return code returns 0, if it fails, it returns 1.

Syntax command lines

DatabaseDeploy.exe /conn <connection string> /langid <language id>

Detailed description of parameters

Parameter	Description
/conn <chain>	The connection string to the database. Note: the database name is also set in the connection string.
/langid <language id>	ID of the database language. Supported values: 1029 - Czech 1051 - Slovak 1033 - English 1031 - German 1045 - Polish Note: this parameter is only applied when creating a new database.
/collation	Collation of the new database, if not specified, will use the default collation of the database server

Note:

You can also set command line parameters in the DatabaseDeploy.exe.config file. The command line parameters take precedence over the settings in the configuration file.
The utility expects the Alvao database definition file AlvaoDatabase.dacpac to exist in the same folder.

Example of use

Create a new Czech database named "ALVAO" on a local computer with SQL Server with instance name "sqlexpress" using integrated Windows authentication:
DatabaseDeploy.exe /conn "Data Source=.\sqlexpress;Initial Catalog=ALVAO;Integrated Security=True;TrustServerCertificate=True" /langid 1029
Upgrade database named "ALVAO" to SQL server on server "SERVER1" using SQL username and password:
DatabaseDeploy.exe /conn "Data Source=SERVER1,1433;Initial Catalog=ALVAO;User ID=user1234;Password=secret1234;TrustServerCertificate=True"

Note:

For more connection string examples, see Connection String Examples.

Did not find what you were looking for? Ask our technical support team.