Tuesday, 18 March 2014

How to copy Syspro settings files to a different server or company

To copy settings files, you need to copy these files:
C:\Syspro7\WORK\Xadm* and XTBL*
Where X is the company prefix you are copying.
Copy these to the new server.
Do not copy the ADM* files; these are the general server settings.
You would also copy (a backup of) the database.

To copy settings to a different company (e.g. from company D to company E):
Copy the settings file to the new server and log into the new company (company E in this example).
Then go to Setup / General Setup / Company Setup; select the company you want to change; go to Options and change the Ledger file company and Inventory file company, as shown in the screen shot below.




Then go to General Ledger / Setup / GL Copy, Merge and Delete (see screen shot below).
Select Copy live ledger, and select the From company (which you would set to company D in this example). This will copy company D’s settings to the company you have currently logged in to.



How to convert a Syspro 6.1 database to Syspro 7

This is a basic procedure to use when you have a parallel installations of Syspro 6.1 and Syspro 7 and are upgrading from Syspro 6.1 to Syspro 7. There is a full procedure published by Syspro; you should follow that full procedure, which includes backing up, balancing, etc. This procedure is the quick-and-nasty procedure for developers to use in a non-production environment.

  1. Log out of Syspro 6.1.
  2. Create a backup of your Syspro 6.1 database.
  3. Move all your Syspro 6.1 settings files from 6.1 to 7:
    Move C:\Syspro61\WORK\?TBL*, ?ARSFMT*, ?SORFMT* and ?TBL* to C:\Syspro7\WORK
    where ? is the company prefix you are copying.
  4. Log into Syspro 7 into the new company.
  5. You should see the conversion wizard start automatically.
  6. Proceed through the wizard.

How to delete a company in Syspro

  1. Log everybody out of Syspro.
  2. Make a backup of what you are about to delete.
  3. Delete these files:
    C:\Syspro7\WORK\?ADM*, ?ARSFMT*, ?SORFMT.* and ?TBL*
    where ? is the company prefix you are deleting.
  4. Delete the matching record from the Sysprodb.SysproAdmin table.
  5. Delete the company’s database.