changes.
| |  | Workflow Studio creates a database called WFDB by default, but if you need more control over the creation of the database we provide all the scripts for you. |
| | | Workflow Studio creates a database automatically as part of the configuration process, but if you are using a database server where your database administrator does not provide the permissions to create the database then you will need to have them run the configuration or provide them with the SQL scripts to manually create the database. |
| | |
| | h5. Workflow Studio SQL Scripts |
| | |
 | | When Workflow Studio is installed there is a sub-folder created in the "Program Files\Citrix\Workflow Studio" called SQLSetup. In this folder are all the scripts that are used to initially create the database, batch files that will create or remove all the tables, and a PowerShell script that will generate customized versions of these files with a different database name. |
| | | When Workflow Studio is installed there is a sub-folder created in the "%Program Files%\Citrix\Workflow Studio" called SQLSetup. In this folder are all the scripts that are used to initially create the database, batch files that will create or remove all the tables, and a PowerShell script that will generate customized versions of these files with a different database name. |
| | |
| | !SQLSetup.png! |
| | |
| | h5. Generating Custom SQL Scripts |
| | |
| | If you want to create a Workflow Studio database with a name other than WFDB you can run a PowerShell script we provide. First you will need to enable the execution of scripts in PowerShell with the [Set-ExecutionPolicy command|http://www.microsoft.com/technet/scriptcenter/topics/msh/cmdlets/set-executionpolicy.mspx|Set-ExecutionPolicy command]. You can reset the script policy after running this script. |
| | | The default scripts are designed to create a database named WFDB. If you want to create a Workflow Studio database with a name other than WFDB you can run a PowerShell script we provide. |
| | |
| | The syntax for running the PowerShell script is (NewDatabaseName should be the customized database you would like to use): |
| | {panel} |
| | cd $ENV:SystemDrive"\Program Files\Citrix\Workflow Studio\SQLSetup" |
| | .\SetDBName.ps1 _NewDatabaseName_ |
| | {panel} |
| | |
| | This will result in new database scripts generated in the folder that you can run against your SQL Server to create a custom database. |
| | |
| | !SQLSetupNew.png! |
| | |
| | h5. Running Custom SQL Scripts |
| | |
| | The syntax for running the SQL scripts is (DBServer should be the server name of your SQL Server): |
| | {panel} |
| | Install.NewDatabaseName.bat _DBServer_ |
| | {panel} |
| | |
| | h5. Using Your Custom Database |
| | |
| | To use your new custom database, you will need to specify the new name when you login. Workflow Studio will remember this setting the first time you enter it for subsequent use. |
| | | Once the database is configured and your SQL administrator has given you access, you will be able to login to Workflow Studio. |
| | |
| | !CustomDB.png! |
