To convert an MS SQL database to Unicode

  1. As is recommended before any activity involving dbupgrade or dbreorg, perform a backup of the database that will be affected.
  2. Verify that the current database is in a good state. At the Landmark command line, type

    dbverify -q dataArea

    Any inconsistencies or issues should be resolved before you continue.

  3. Run changeda -s for each database space in order to change the database server character set to UTF-16. At the Landmark command line, type

    changeda -s charset=UTF-16 productLine databaseSpace

  4. Run changeda -d in order to change the validation character set in Landmark to UTF-16. At the Landmark command line, type

    changeda -d charset=UTF-16 productLine

  5. Rebuild the data area. At the Landmark command line, type

    stagelandmark dataarea

  6. Perform the database reorganization. At the Landmark command line, type

    activatelandmark dataarea

  7. Verify that the database reorganization was successful. At the Landmark command line, type

    dbverify -q dataArea