Switch Schemas Used During an App's Lifecycle
When you use your own DB schema, you can switch the schema that your app connects to during its lifecycle. For example, you might want to use a particular schema during the development phase, but switch to another one for testing or for production. You do this using application profiles.
Application profiles help to define combinations of servers and security settings for every environment that you want to deploy your visual app to. You define multiple profiles for an app, with each one containing a different configuration appropriate for the environment. For example, you can have a profile for testing that connects to a test environment, then associate it with the schema used to access testing data. Similarly, you can associate a production profile with a schema for live data.
If a profile isn't explicitly mapped to a particular schema, it will always use the default schema.
To associate a schema with a profile: