How do I move a project from one server to another?

Before you start

In order to safely and efficiently move a Discovery Hub project from one server to another, you have to consider how your current setup is configured. Without considering these key questions, you may run into problems during the migration process.

Do you use multiple environments?

If so, are they located on this server?

If not, can you connect to them from the new server?

Are you using history in any of your projects?

Do the users, user groups and service accounts have the same access and rights to the new server?

Do you use SSIS?

If so, is SSIS installed and running on the new server?

If SSIS is running on the new server, can all the users and service accounts access the Integration Services server through SQL management studio?

If not, see the Troubleshooting section

Do you use Analysis Services?

If so, is SSAS installed and running on the new server?

Do you have the installation files for the version of Discovery Hub you are currently using?

How to move from one server to the other

Broadly speaking, there are two ways to transfer a project across servers. One is to backup and restore Discovery Hub databases onto the new server. The other way is to transfer only the project metadata using a project export.

Transferring only metadata is fast and easy, but is not appropriate in all cases. The primary drawback is that data not currently present in the source system will be lost in a metadata-only transfer. If you are using history in your project, especially Type II SCD functionality, we strongly recommend using database transfer and restore instead.

Method 1: database backups

Backup and restore all databases

Create full backups of your project repository(ies) and other related databases.

When you start it up the first time you point it to the newly restored repository and press ok.

Update multiple environment settings if applicable

After you did the first steps, you need to log into Discovery Hub as the server service user.

Point it to the other repository.

Open the "Windows Service Setup"

Start the Server Service as that user account and close the program.

Open the program as the first user and open the "Environment Properties".

You should be able to see all environments and global databases.

Deploy/execute all projects. You do not need to run a full deployment, as the underlying database structure will be present thanks to the full migration process.

Method 2: project exports

Transfer project metadata

Start the current version of the program and open a project.

If you use multiple environments, these settings won’t be saved, so a good idea would be to set all the global databases back to the project settings before you export them. Uncheck the Use global database field and press OK.

Then click on File and then Export.

Save it somewhere that is available from other user accounts. The name should be something like ProjectName_V171205. It is important to add the version as it only works for this version of Discovery Hub.

If you have more than one project, then press close project, open another project and export that as well. Keep doing it until you have no more projects.

After you have exported those you need to install the same version of TX DWA as you had on the old server. This is because the exported projects are locked to the version of the TX DWA software they have been exported from. Upgrade or install TX DWA

Import metadata and rebuild databases

Install and register the TimeXtender software.

When prompted, create a new repository and give it the same name as the old repository.

Import the project.

When prompted, run the connection manager

Run the wizard and remember to create all the databases, as they are not present on the new server.

Update multiple environment settings if applicable

Any environmental settings for this environment will be lost with this transfer method.