Knowledge Base Article

Home Page > Knowledge Base > KronoDesk

Home Page > Knowledge Base > Spira Platform

Home Page > Knowledge Base > Spira Platform > SpiraPlan

Home Page > Knowledge Base > Spira Platform > SpiraTeam

Home Page > Knowledge Base > Spira Platform > SpiraTest

Article How do I migrate data from a trial installation of Spira or KronoDesk to the production one?

by Adam S on Tuesday, June 9, 2015

This is a common need, since you may have installed SpiraTest, SpiraPlan,  SpiraTeam, or KronoDesk  on a workstation to evaluate its capabilities and now need to install it on a production server for real use, but you don't want to lose all your existing data.
To migrate your installation and not lose your data, please follow these steps (they are written using SpiraTeam as an example, but they apply to SpiraTest, SpiraPlan, or KronoDesk, you just need to change the database name in the examples below):
  1. First backup the live data on your demo instance of SpiraTeam via SQL Server Management Studio
  2. Next make a copy of the Attachments folder that is used to store document attachments.
  3. Now install a clean version of the same version of SpiraTeam onto your production instance. When you log in it will have just the sample data.
  4. Now delete the 'SpiraTeam' database on your live server. This is the one with just the sample data
  5. Now restore the backup from the demo box onto the live server with the database name 'SpiraTeam'.
  6. Now copy the attachments that you backed-up in step (2) to the Attachments folder on the new server.
  7. Finally run the following SQL command to relink the SpiraTeam SQL Server login with the SQL Server user (otherwise the DB will throw an error):
    1. Using SQL Server Authentication
      USE SpiraTeam
      GO
      EXEC sp_change_users_login 'Update_One', 'SpiraTeam', 'SpiraTeam'
      GO
    2. Using Windows Authentication on Windows 2003/2008/Vista/7
      USE SpiraTeam
      GO
      ALTER USER SpiraTeam WITH LOGIN = [NT AUTHORITY\NETWORK SERVICE]
      GO
    3. Using Windows Authentication on Windows XP
      USE SpiraTeam
      GO
      ALTER USER SpiraTeam WITH LOGIN = [MACHINENAME\ASPNET]
      GO
Attachments
Article Info
Last Updated: 6/9/2015
Article ID: KB153
# Views: 696
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2016 | Licensed to Inflectra Corporation.