Skip to main content

Usercube-Export-Bacpac

This tool exports the database to a bacpac file, as a backup.

Examples

The following example generates to <C:/identitymanagerDemo> a bacpac file from the Usercube database with the given connection string and based on the bacpac template from the SQL folder.

Code attributes enclosed with <> need to be replaced with a custom value before entering the script in the command line.

./identitymanager-Export-Bacpac.exe --database "<Usercube>" -s "<data source=.;Database=Usercube;Integrated Security=SSPI;Min Pool Size=10;encrypt=false;>" --bacpac-path 0 --template-bacpac-path "<C:/identitymanagerDemo/SQL>"

Arguments

The list of arguments:

Argument NameTypeDescription
--database-connection-string (-s) requiredStringConnection string of the database.
--database requiredStringString Name of the database.
--template-bacpac-path requiredStringPath of the empty bacpac file containing the database schema. NOTE: The template is provided among Usercube's artifacts, and can be generated manually by exporting an empty Usercube database as a bacpac file.
--temp-bacpac-path optionalStringString Path of the temporary folder storing the database's data.
--bacpac-path requiredStringString Path of the generated bacpac file.
--without-history default value: falseBooleantrue to exclude history data.
--without-job-instances default value: falseBooleanBoolean true to exclude job and task instances.
--without-workflow-instances default value: falseBooleanBoolean true to exclude workflow instances.
--without-campaign-instances default value: falseBooleanBoolean true to exclude access certification campaign items.
--without-temp default value: falseBooleanBoolean true to exclude the data of temporary tables.
--without-all default value: falseBooleanBoolean true to exclude history data, job and task instances, workflow instances and access certification campaign items. Remember, this option represents the usual use-case.
--log-level optionalLogLevelLevel of log information among: Verbose; Debug; Information; Warning; Error; Fatal.