Create a new tenant database

Last published at: July 24th, 2023

To define a tenant, a tenant database must be created.  A blank database can be created within the SQL server using SQL Enterprise Manager or any other database management tool.  You can also create a new database using the following UI:

Once the dialog is displayed, give a name for the new database, in this case, let’s call it “FlowWrightTenant1”.

Click the “Create” button to create the new database.  If successful, the database will be created within the same database server as the current FlowWright database.  If you like to the database in a different database server, then use the option “Connection String” to provide a different connection string to another server.

If you like you can check and verify within SQL server to make sure the new database “FlowWrightTenant1” was created.

Note: The new tenant should also create the forms master script file. Navigate to C:\inetpub\wwwroot\cDevWorkflow\Tenants\GUID\js\formEvents to locate 'formWidget.js' file.

The next operation is to add the proper tenant tables and data to this newly created database.  Use the following menu option:

Once the dialog is displayed, enter the database name as “FlowWrightTenant1” and select “Template” as the selection for where will replicate tables and data from.

Click the “Create” button to set up the new database with tables and configuration data.  Once this operation is successful, the database should contain tables and configuration data.

If you like, you can verify the database tables and their data using a database management tool such as SQL Enterprise manager.