Migrate large databases manually

While migrating tenant data without ARIS databases, backup the databases separately. Administrators have multiple options for manually backing up databases: In ARIS Server Administrator using the backup or backupasn commands, in ARIS Architect using the Back up database Backup functionality in the pop-up menu of a database.

When migrating data, the new database schema is applied and the content is migrated. The databases are optimized on the fly. As the optimization can be time-consuming, only the workspace content of databases will be optimized automatically. If required, change lists can be optimized later.

Prerequisite

You log in as a system user.

Procedure

  1. Start ARIS Server Administrator in your ARIS 9 installation and connect to the tenant that contains the database.

    You can start ARIS Server Administrator from any computer on which the ARIS Client or ARIS tools are installed either in interactive mode (Start > Programs > ARIS > Administration > ARIS Server Administrator) or command-line mode by opening the command prompt from the directory <ARIS installation directory>\server\bin\work\work_abs_<s, m, or l>\tools\arisadm\arisadm.bat. In command-line mode you can perform actions automatically as there are no prompts in this mode.

  2. Establish a connection to the ARIS Server and tenant:

    Syntax: server <ARIS Server name>:<port number> <tenant> <user name> <password>

  3. Example: server arissrv:1080 default system manager or server arissrv:443 default system manager -ssl

  4. To back up a database <dbname> as an adb file in a directory <archivedir>, syntax:

    backup <dbname>|all <archivedir> [-p <password for encryption>] [<alternatename>]

    for example:

    backup myARIS9database d:\backup

    or, as recommended:

    backup all d:\backup

  5. To back up the state of a specified change list number <asn> from a versioned database <dbname> in an adb file in a directory <archivedir>. head or work can be used instead of <asn>. While head represents the last versioned state, work represents the current state that is not versioned yet. This command is recommended to reduce the size of large versioned databases. Syntax:

    backupasn <dbname> |all <archivedir> <asn> |head|work [-p <password for encryption>] [<alternatename>]

    The database is backed up. Back up all required databases on all tenants as well.

    Warning

    Make sure that the ARIS 10 relevant tenants have already been migrated, before restoring the databases.

  6. Backup the system database to save your customized content, for example, user defines scripts or ARIS method modifications. Enter:

    backupsystemdb d:\backup

  7. Backup the databases and system databases of all other tenants as described.

  8. Start ARIS Server Administrator in your ARIS 10 installation and connect to the tenant that will manage the database.

  9. To restore a database <dbname> from an adb file <archive> or all adb files from a directory, enter:

    restore <dbname> |all <archivedir> [-p <password for encryption>] [<alternatename>], for example:

    restore d:\backup\myARIS9database.adb

    or, as recommended:

    restore d:\backup

  10. Restore the system database, enter, for example:

    restoresystemdb d:\backup\arissystemdb.adb

  11. Restore the databases and system databases of all other tenants as described.

  12. If ARIS document storage is in use, timestamps must be adjusted and all migrated databases must be processed by a report.

  13. Restore the United Motor Group database from the ARIS installation package (..\Content\Databases). This will make new content available mandatory for dashboards (ARIS Aware).

The database is migrated. If it is a versioned database the workspace content is optimized.

You are recommended to optimize the change lists of versioned databases as well. To do so use the prepareoptimizedb ARIS Server Administrator command.