How to create a staging server for OfficeClip

Reading Time: 3 minutes
Staging servers are needed when you do not want to put a new release directly into the production environment. You may want to make sure if some new feature needs some training, or your team may feel comfortable testing the new release before putting it in production.

This article provides a step-by-step walk-through of creating a staging server. It also explains how you can use a pre-configured amazon ec2 instance as staging server.
  1. Select appropriate machine: OfficeClip runs on Windows 7 or higher for client operating system and Windows 2008-R2 or higher for server operating system. The staging machine could be also virtual machine environment with at least 2 GB of memory (4 GB is better for larger databases) and have at least 20GB of disk space (or at least 10GB more than the size of your upload folder).
  2. Backup information from production: You will need the backup of your production database, upload folder and the configuration files (web.config, dynamic.config and db.config). This can be done individually (as per your organization backup policy) or by running OfficeClip.Tools.OCBackupGUI.exe from the OfficeClip installation directory.
  3. Install OfficeClip on the staging server: Download the recent version of OfficeClip from our website at and click on setup.exe. This will also install Sql express to the staging server (if you would rather use your own sql server for the staging, then run SetupNoSql.exe). Once the installation is complete, create an account on the system and make sure OfficeClip applications comes up.
  4. Restore database, files and IIS settings: Do a database restore of the backup you created in step 2 to the same database of the staging server. If you are doing this manually, you can do this using the Sql Management Studio. Next restore the upload folder from production to the same folder in the staging server. Alternatively, run OfficeClip.Tools.OCBackupGUI.exe from the OfficeClip installation directory and restore the database file and the upload folder (do *not* restore the configuration files). If you made any IIS settings changes in the production, you need to do those in the staging server also. 
  5. Change config files and customization: Next copy the dynamic.config file from the production to the staging server. Make sure that some of the values in the dynamic.config file may be different from your production environment (if you have changed it manually in the production), you will need to change it appropriately. If you have done any customization in OfficeClip using the custom folder, then you will need to copy the web.config file from the production environment to the staging server. Also make sure you copy the custom folders (as given by the value of customXml key) to the staging server. Finally check all the folders under App_Themes folder and copy to staging server if they are missing.
  6. Login and Test: Now login to the staging server with your production login id and password. It should automatically upgrade the OfficeClip database and allow you to login. This is your staging server and you can test it now.
  7. Update the production server: When you are ready to move the changes to production server, just upgrade the production environment with the same release.

Making Amazon Ec2 instance as a staging server

OfficeClip provides a free Amazon ec2 setup where you can run your staging server. This is a good strategy because after testing you can terminate the staging server and there is no need to maintain it. If you want to go this route, read this blog:
How to use Amazon ec2 with OfficeClip and then start from Step 4 above.

photo courtesy Flickr Creative Commons Attribution