Connection string information must be present in the Foundation DBUtils User Interface before you can conduct any database actions. If you have not edited the appsettings.json prior to launching FoundationDBUtilsUI.exe, you can add connection string information within the user interface.
To create a new connection string in the Foundation DBUtils User Interface:
- Launch FoundationDBUtilsUI.exe.
- Click Add New. The Edit Connection String dialog box is displayed.
- Select a provider from the Database Provider drop-down list. You must enter different information based on which database provider you selected.
- To test the connection to the database using the connection string information you entered, click Test Connection.
- Click Save.
- To encrypt your connection string configuration information, click Protect Configuration.
- Save your connection string information to the JSON configuration file.
You can also edit or remove existing connection strings. To edit an existing connection string, select the string and click Edit. To remove an existing connection string, select the connection string and click Remove. Upon editing or removing a connection string, you must save the updated information to the JSON configuration file.