The Benefits of Setting Up a Test Company in Sage 200 & How To do it

In Sage 200 by Tamara

Reading Time: 2 minutes

Many times we have found ourselves wanting to ‘test’ entering transactions, running reports and adding new accounts without using our ‘real’ data but not implementing it on our live Sage 200 company.

This is where a Test Company comes into play! 

What you need to know…

This is essentially a company where we are able to test, play, amend and delete data that we have entered into Sage.

Whether you are:

  • Questioning the end result from a transaction
  • Unsure of the result from changing a setting
  • Carrying out training with new employees
  • Experimenting with a new process
  • Trying to improve on your Sage knowledge

A test company is a great resource that enables you to cover all of these and more.

Setting up a test company is easy. If you don’t already have one, we highly advise that you set one up.

Fortunately, we will be covering that today.

How to set up a Test Company in Sage 200

Prior to setting this up, a few key pieces of information are required.

You will need:

  1. Access to System Admin
  2. Access to the SQL Server
  3. The current live company database name.

Firstly: Head to System Admin > Select Companies from the columns on the left-hand side.

From here you will need to make a note of the database name assigned to your current live company.

With this then you need to head to the SQL Server and create a backup of that database.

(If you are unsure on how to create a back up please see our blog here…)

Once the backup is complete you need to restore this as a new database.

(If you are not familiar with setting up a new company please see our guides here…)

Once this is completed, you will need to create a new company within the system admin.

(If you are not familiar with setting up a new company please see our guides here…)

We would suggest that you call the company names the same as your live company, only with test at the end like so:

  • Live company name = Small Soldiers LTD
  • Test company name = Small Soldiers LTD Test

This ensures the two companies are never selected in error.

You should now open Sage and select the test company from the list of companies, then that is your test company all set up.

Getting the most out of your Test Company

To ensure you are getting the most out of your test company, we suggest you regularly update it.

Similar to the installation of the test company, updating it is simply taking a backup of the live data. The only difference is we are going to restore the backup over the existing test company’s database.

When the process is complete and you have successfully completed your backup and restore, it will be fully up to date.

So, there we have it. I hope you were able to follow all steps easily… Until the next time!

Did you enjoy this blog?

Here at itas, we love feedback. Please do let us know if you found this blog useful, or not.

If you still have any questions please refer to our Blog Page!

Sage 200 Training CTA