Database

The Database node contains a selection of tools for working with and manipulating the solution database – available to Administrator users only.

Please backup your database before using any of these tools.

If you don’t have access to your database or don’t know how to back it up, don’t use the tools.

The Search & Replace tool lets you select a database, a table and a field – then search for and replace values therein (Figure 2.1).

Use Find to find all records matching a value, then Replace all to replace all values found with the content in the Replace with field.

Figure 2.1 The Search & Replace tool

The SQL Firehose tool is a tool for executing SQL statements against your database - it is described in more detail here.

Using the Setup node you can change database connection configuration or add an alternative database connection to the solution (Figure 4.1).

Figure 4.1 The Database setup options

The Indexes node provides a user with the rigt permissions (db_owner) with the ability to rebuild the SQL indexes of the solution database (Figure 5.1).

Figure 5.1 Rebuilding SQL indexes