In the Database page > Advanced tab, you can create various DB connection profiles which include database connections to be used in different environments, for example, database connections for the development environment, testing environment, production environment, etc.
Each DB connection profile will have a corresponding Applications.[DBConnectionProfile].json created in the PowerServer C# solution > ServerAPIs project > AppConfig for storing its settings such as database connection cache(s), transaction-to-cache mapping(s) etc. For example, the default Applications.json stores the settings of the "Default" connection profile, Applications.Test.json stores the settings of the "Test" connection profile, Applications.Production.json stores the settings of the "Production" connection profile.
You can then decide which connection profile to be used in the application by selecting the profile and clicking the Set as Current button. The name of the current profile will be stored to the "POWERSERVER_ENVIRONMENTTYPE" setting in the ServerAPIs project > AppConfig > AppConfig.json.
To create a new DB connection profile:
-
Click New in the DB connection profile group.
-
In the New DB connection profile dialog box, specify a name for the DB connection profile, for example, production.
-
To create the new connection profile from an existing profile, you can select the check box below and then select an existing profile to clone from.
