Configure a Different Database as the Repository

Uniface uses SQLite as its default Repository. To use another database, you need to configure the Uniface IDE after it is installed.

You must have administrator privileges to create the database and the tables.

Ensure that the database you want to use is supported as a Uniface Repository. See the Platform Availability Matrix.

  1. Create a new database. For database servers, create a new database in your target database environment. For more information, consult your database product documentation, or contact your database administrator for assistance.
  2. Generate the sql scripts for your repository by starting the IDE (on the default repository) with the /genSql command line switch withe the /meta option. To do this you need to configure your ASN file and provide parameters as explained in the documentation of /genSql.
  3. Create the database tables in the target database environment using the SQL script files you have generated.
  4. Make sure the dbms_development.asn assignment file in UnifaceVersion\uniface\adm has the correct database connector and parameters.

    Alternatively, you can edit another assignment file to override the default specified in Uniface Version\common\adm\dbms_development.asn. For example, Uniface Version\uniface\adm\ide.asn.

    Follow the instructions and settings in these files to direct the Uniface applications to use your newly created database. For more information, see the Uniface database connector documentation for your database.

Related Topics