Relocate your data

There are several ways you can relocate data to a different location:

Use the Relocate Data feature – use this to move data to a new location
Manually moving the data – use this alternative option to move multiple companies at once

You can read more information on how to perform each option below.

To check where your data is currently held, you can go to Help then click About. In the Program Details area, check the Data Directory.

Using the Relocate data feature

This process moves the contents of the existing Company_XXX folder into the folder you specify in the Relocate Data window.

First, create a folder in the location you'd like to move your data to. We recommend naming this folder the same as your existing data, such as Company_001.

TIP: It's easy to check the folder name of the company you're logged into. Click Help, then About and check the Data directory under the Program Details heading.

After you create the new folder, complete the following steps to move the company data.

Click File then click Relocate Data.
Enter the path to the new folder in the Data Path section.
Click OK then click OK.

TIP: Depending on the size of your data and where it's moving to, this may take several minutes.

If you have a multi-company licence, you can repeat the steps above for each company.

To check the data has relocated correctly, click Help then click About. In the Program Details area, check the Data Directory. This shows the new data location.

If you have a multi-user version of Payroll, link any other client computers to this new location so they can access the data. For further information about this, refer to the 'Link other computers to the new data location' section.

Moving data manually

Instead of using the Relocate Data feature, you can manually copy your existing Company_XXX data folders to a new location then connect payroll to them.

This is best if you have multiple companies to move, or if you're moving your data temporarily, for example to troubleshoot an issue.

To do this, check the existing data location and decide where you want to move your data to. This can be a different location on the same computer or to a server on a network.

You then copy the Company_XXX folder that contains your data. This folder contains your Paydata, Submissions and Archive folders, along with other data. You can then paste the folder in the new location.

Close Sage 50 Payroll.
Browse to your existing data location.
Right-click your Company_XXX folder, then click Copy.
Browse to your new, desired data location.
Right-click then click Paste.

The next step is to connect Sage 50 Payroll to the new data location using the steps below.

Link other computers to the new data location

If other people connect to the data you moved using software on their computers you need to connect their software to the new data location.

Depending on your software licence and how you need to connect, there are three methods:

Use the Startup Wizard to connect to existing data

Single Company Licence

This is the best method to use if you have a single company licence and need to connect to the new data location. This is primarily used if you've moved the data manually.

Click to view steps >

Open Sage 50 Payroll.
Click Help then click About.
In the Program Details area, make a note of the Settings directory.
NOTE: The default settings directory is C:\PROGRAMDATA\Sage\Payroll\.
Close Sage 50 Payroll.
Browse to the Settings directory noted in Step 3 then:
- Rename Payroll.usr to Payroll.old
- Rename Paydata.txt to Paydata.old
- Rename Company_001 to Company001old
  - You must remove the underscore '_' from the Company_001 folder name
Open Sage 50 Payroll then enter your serial number and activation key.
Click Next then choose the Select an existing set of Windows data option then
Click Next then browse to the Payroll.mdb file on the server.
Click Next then click Finish.

Add a new company - Multi-company licence

This is the best option if you have a multi-company payroll licence. You can add the new company to your list and then remove the old one if required.

This is best done for other computers that need to connect to a company after it has been relocated or if you've moved the data manually on your main PC.

Click to view steps >

Open Sage 50 Payroll.
Login to any existing company you can access.
Click File, then New Company.
Click Next, then Select an existing set of Windows data.
Click Next, then Browse to the new data location.
Click Next, then Finish.

This will then connect the new data location to your Sage 50 Payroll. You should then be able to login and see all your data there.

If need be you can delete the old data location from your Sage 50 Payroll by selecting File, then Delete Company from within any other existing company. You can look at the Path to Data field to identify the old company to be deleted.

Copy the Payroll.usr file

This is the best method to use when you have relocated multiple companies across multiple computers.

For this step to work, one PC must be already set up and connected to all the necessary companies with the correct data locations. Follow the steps above to set up the first PC to connect to the data.

Click to view steps >

On the computer you're copying the file from:

Open Sage 50 Payroll.
Click Help then click About.
In the Program Details area, click the Settings directory link.
Copy the Payroll.usr file.

TIP: Copy the file to a memory stick, or a network location that can be accessed by the computer you need to copy it to.

On the computer you're pasting the file to:

Copy and paste the Payroll.usr file to the Sage 50 Payroll Settings directory folder

[BCB:183:Oli Footer CB with feedback:ECB] [BCB:19:UK - Sales message :ECB]