Skip Navigation LinksALVAO 11.0ALVAO Asset ManagementImplementation of the system in the organisationInstallationDatabaseDeploy Skip Navigation Links.


Change Alvao version
Change language

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.
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

  1. 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" /langId 1029
  2. 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"
Note:
For more connection string examples, see Connection String Examples.

 

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