Skip to main content
Sign In
 

 

entire site this section
Go Search
Home
Quick Start
User Guide
Knowledge Base
Training
Discussions
Downloads
Platform
   IdeaSpace

 
 
VersionOne Community > Knowledge Base > FAQs > Q10164
 
We want to move the VersionOne database from one MS SQL database server to another.  Do you have a documented procedure for this?  The VersionOne server will remain the same.

Note: this information summarizes steps outlined in both the Installation Guide and online Help.

To move a VersionOne system from one server to another, you can follow the steps below. This setup assumes the web and database servers will both be moving.

Moving to a New Server

  • Using Enterprise Manager: back up the database on your current system
  • Ensure your new server is set up according to the System Requirements section of the documentation
  • Using Enterprise Manager: on the new server, Restore the database backup from the current system as the name you just deleted
  • Run the install program to create a new system on the new server
  • During the install when asked to attach to a database, go ahead and attach to the database you restored on the new server

If only the database is moving, the easiest thing to do is to reinstall a new system that points to your new sql server. That allows the VersionOne installation program to do all the coordination work and keep everything in synch. The steps for this are below:

  • Ensure your new server is set up according to the System Requirements section of the documentation
  • Using Enterprise Manager: back up the database on your current system
  • Uninstall the old application
  • Using Enterprise Manager: on the new server, Restore the database backup from the original server
  • Run the install program to create a new system;  attach to the newly restored database when prompted

 


last modified: 1/15/2010 10:27 AM