Skip to main content

Moving Datamart Servers

Instructions for installing Data Mart using an existing database transferred from another system.

Before You Begin

If you are also moving the Digital.ai Agility instance, make sure you have performed the steps discussed in "Moving Digital.ai Agility Core Servers".

Steps

  1. Run the Digital.ai Agility Data Mart Setup .EXE program.
  2. Select Install a New Instance.
  3. Name your new application.
  4. Follow the prompts to reach the database selection page When prompted for the Data Mart database, Create a new database When prompted for the Analytics Meta-Data Database, attach to the existing database.
  5. Select OK after the upgrade is complete.
  6. Run the Data Mart ETL program.
  7. If you configured SMTP you will need to reenter your SMTP server password.
  8. Update your Digital.ai Agility Core system to use the new Analytics URL.
  9. Verify the installation.

Do not use SQL Server’s ‘Copy Database…’ or other DTS-based db replication tasks, as they may not accurately replicate all database structures. In order to ensure the integrity of the database, you must use a full Backup (‘Backup type: Full’) and Restore.