Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Web Help Desk (WHD) > Web Help Desk (WHD) Documentation > Web Help Desk Administrator Guide > Installation requirements > Migrate from an Embedded FrontBase to an Embedded PostgreSQL Database

Migrate from an Embedded FrontBase to an Embedded PostgreSQL Database

Table of contents
No headers
Created by Steve.Hawkins, last modified by Anthony.Rinaldi_ret on Jul 18, 2016

Views: 363 Votes: 0 Revisions: 5

See Converting from other Databases to PostgreSQL on the PostgreSQL website for information about migrating external and unsupported databases to PostgreSQL.

See Database datatypes for information about mapping database datatypes for PostgreSQL and to each other.

  1. Ensure that your current installation is running an embedded FrontBase database.

    If your configuration uses another database or you intend to run a non-embedded PostgreSQL database, you cannot use the upgrade database export feature.

  2. Ensure that the whd.properties file is located in the <WebHelpDesk>/conf directory.
  3. Log in to Web Help Desk.
  4. Start the database export feature.
  5. When prompted, verify that you have enough space for the database migration.
  6. Click Continue.

    The database migration program migrates the FrontBase data to the PostgreSQL database.

    During the migration, the program verifies the PostgreSQL database tables against the FrontBase database tables. When completed, the migration program shuts down the embedded FrontBase database.

    Next, the program prompts you to update the database with your current Web Help Desk installation.

  7. Click Continue.

    Web Help Desk is now running an embedded PostgreSQL database.

 
Last modified

Tags

Classifications

Public