The Database tab of the Project Properties sheet in USoft Binder is used to specify the following properties:
Separate Properties for Repository and Application
Choose this option box if you want to use different database accounts for repository tables and runtime application tables. Runtime application tables are used during development for testing and prototyping. If you choose this option, the Definer, Windows Designer and USoft Batch tables are placed in one account, and the application tables in the other account.
IMPORTANT: If you choose this option, you need Authorizer tables in BOTH accounts. You must run Create Tables for the Authorizer twice, once with the Authorize for Repository option for the Authorizer item checked, to create Authorizer tables for the repository user, and once with the Authorize for Repository option for the Authorizer item unchecked.
The separate database accounts may be on different types of databases, for example, Oracle vs. Sybase.
See also Defining a Separate User Environment.
Common Properties for Repository and Application
Choose this option box if you want to use the same database account for repository tables and application tables. In this case, development team members share this account not only for development but also for application testing and prototyping.
The following 6 properties, called database properties, apply to both repository and application if you have selected "Common Properties...". If you have selected "Separate Properties...", press the Define button to specify separate database properties for the repository and for the application (12 in total).