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"
Did not find what you were looking for? Ask our technical support team.