Skip to main content
System StatusContact Support
VersionOne Community

Moving Datamart Servers

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

Before You Begin

Refer to SQL Server Management Studio Documentation for instructions on perform these tasks:

  • Restore the database on the new system from a complete database backup obtained from the previous system.

  • Restore the database on the new system from a complete database backup obtained from the previous system.

  • Restore the VersionOne Analytics Meta-Data database on the new database server from a complete database backup obtained from the previous system.

Steps

  1. Run the VersionOne 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 Lifecycle 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.

  • Was this article helpful?