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.
Search & Replace
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.
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).