Moving Harvest to a new server

Products

• CA Harvest Software Change Manager

Issue/Introduction

What are the steps that need to be taken to move the current Harvest server and/or database to a new Windows or Linux server?

Environment

Harvest Software Change Manager all versions

Resolution

• If you're moving only your database to a new server:
• Install SQL Server software on the new server
• Shut down Harvest
• Take a full backup of the Harvest database on the existing server.
• Restore the backup of your database on your new server
• (if needed) Install SQL Server Management Studio (or ODBC Drivers and Client Tools) on the Harvest server
• Execute HDBSetup and use CO option to set up a data source that points to the new location for the database, and to encrypt the userid and password.
• Start up Harvest
• If you're moving only Harvest to a new server:
• Install the Harvest software on the new server
• Execute HDBSetup and use CO option to set up a data source that points to the location for the database, and to encrypt the userid and password.
• Shut down Harvest on the old server
• Start up Harvest on the new server
• If you're moving both to new servers:
• Install SQL Server software on the new database server
• Shut down Harvest
• Take a full backup of the Harvest database on the existing server.
• Restore the backup of your database on your new server
• Install the Harvest software on the new Harvest server
• Install SQL Server Management Studio (or ODBC Drivers and Client Tools) on the Harvest server
• Execute HDBSetup and use CO option to set up a data source that points to the new location for the database, and to encrypt the userid and password.
• Start up Harvest

Additional Information

Additional information about migrating the Harvest database to a new server can be found in these articles:

Harvest - how to migrate the SQL Server database

Harvest - how to migrate the Oracle database