Data Migration (DMG)

This function is used when implementing SunSystems and is fully explained in the Guide to Migrating Data From SunSystems 4.

  1. Select Data Migration (DMG) from the main SunSystems menu.
  2. Specify this information:
    Database Code SunSystems v4
    Enter the database code for the SunSystems v4 database that you wish to migrate.
    Note: The databases created in SunSystems v4 versions, using the function DB=Database Definition, are now referred to as business units in SunSystems v6.
    Business Unit Code SunSystems 6
    Enter the v6 business unit code for the migrated data.
    Static/Payment Terms
    Indicates the number of table rows migrated and not migrated after the Static data migration button has been clicked. The number of Payment Terms table rows is also displayed.
    Transaction
    Indicates the number of table rows that were successfully migrated after the Trans data migration button has been clicked.
    Archive
    Allows you to enter specific, or a range of, years before clicking the Archive data migration button.
    Data Check
    Checks for invalid dates in the Ledger backups and for lower/mixed case codes in the Static and Ledger backups and validates bank and asset entries, and analysis code lengths to ensure they are not longer than the SunSystems v6 analysis dimension they are migrated to and address/account relationships.
    Apply RI Button
    This enables referential integrity to be applied to the specified business unit tables and system tables.
    Note: 
    • After you have migrated the data, you must run the Payment Terms Update (PYU) utility. This ensures that all the due dates in the ledger file are updated.
    • All log files (.log) and work files (.wri) generated by the system are stored in this folder: storage://Application/Data Migration